DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How to predict purchase intent using SQL
ktyborowski profile

How to predict purchase intent using SQL

#machinelearning #sql #nlp #mindsdb
4
Comments
5 min read
The best SQL function you never heard of
radbrt profile

The best SQL function you never heard of

#sql #snowflake #oracle
1
Comments
5 min read
YugabyteDB: when provisional records are applied to RegularDB from IntentsDB
franckpachot profile

YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

#distributed #sql #transaction #yugabytedb
1
Comments
5 min read
Object dictionary
emanuel_allely profile

Object dictionary

#discuss #sql #database #programming
5
Comments
1 min read
MySQL: Searching multiple columns at once without LIKE
massivebrains profile

MySQL: Searching multiple columns at once without LIKE

#sql #mysql
11
Comments
2 min read
Introduction au SQL
cedric921 profile

Introduction au SQL

#sql #database
Comments
2 min read
SELECT * FROM S3 | Query data via S3 Select
srcecde profile

SELECT * FROM S3 | Query data via S3 Select

#s3 #aws #s3select #sql
8
Comments
3 min read
Ingesting with CrateDB
marijaselakovic profile

Ingesting with CrateDB

#cratedb #database #performance #sql
Comments
7 min read
generate_series() in Oracle like in PostgreSQL
franckpachot profile

generate_series() in Oracle like in PostgreSQL

#oracle #postgres #sql
3
Comments
2 min read
How to integrate cloud data into your analytics stack with Cloud2SQL
scapecast profile

How to integrate cloud data into your analytics stack with Cloud2SQL

#programming #sql #productivity #database
2
Comments
3 min read
Why you should use Azure Database for PostGreSQL storage
richkurtzman profile

Why you should use Azure Database for PostGreSQL storage

#sql #azure #cloud #webdev
4
Comments
2 min read
Dead easy NULL-aware comparison in Oracle with DECODE
pesse profile

Dead easy NULL-aware comparison in Oracle with DECODE

#100codeexamples #sql #oracle
Comments
2 min read
How Long Does It Take To Create An Index?
andatki profile

How Long Does It Take To Create An Index?

#postgres #sql
10
Comments
2 min read
top 3 linux apps for productivity 🐧
vabro profile

top 3 linux apps for productivity 🐧

#sql #database #programming
3
Comments
1 min read
Database 101: Data Consistency for Beginners
danielhe4rt profile

Database 101: Data Consistency for Beginners

#beginners #database #sql #architecture
467
Comments 44
7 min read
A Guide to Memoization in Ruby
tripplea profile

A Guide to Memoization in Ruby

#opensource #webdev #sql #sideprojects
Comments
7 min read
SQL doesn't need the "Single Table Design" but Composite Primary Keys
franckpachot profile

SQL doesn't need the "Single Table Design" but Composite Primary Keys

#sql #dynamodb #composite #keys
13
Comments
13 min read
The Benefits of Using a Graph Database Instead of SQL
memgraphdb profile

The Benefits of Using a Graph Database Instead of SQL

#memgraph #database #sql #graphdatabase
Comments
10 min read
How to JSON in PostgreSQL®
ftisiot profile

How to JSON in PostgreSQL®

#postgres #json #query #sql
1
Comments 2
2 min read
Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs？
jbx1279 profile

Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs？

#database #sql #programming #datascience
Comments
13 min read
🚀Batched Nested Loop to reduce read requests to the distributed storage
franckpachot profile

🚀Batched Nested Loop to reduce read requests to the distributed storage

#yugabytedb #sql #distributed #database
2
Comments
8 min read
Scalable Sequence for PostgreSQL
franckpachot profile

Scalable Sequence for PostgreSQL

#postgres #yugabytedb #sql #database
4
Comments
6 min read
Real-world Chrome extensions for web developers
mohammad-mghn profile

Real-world Chrome extensions for web developers

#mysql #sql #cli #database
5
Comments
2 min read
SQL Commands Cheat Sheet
shivams1007 profile

SQL Commands Cheat Sheet

#sql #mysql #database #cheat
3
Comments
11 min read
Map x flatMap, entendendo a diferença na prática
trinity_ profile

Map x flatMap, entendendo a diferença na prática

#discuss #sql #analytics #opensource
Comments
2 min read
loading...