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.
Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite
the_infinity profile

Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

#beginners #database #coding #sql
14
Comments 4
12 min read
Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`
franckpachot profile

Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

#yugabytedb #postgres #distributed #sql
2
Comments
4 min read
Dapper mappings, which is best?
victorioberra profile

Dapper mappings, which is best?

#dapper #csharp #net #sql
7
Comments 4
2 min read
From GUI to CLI: Transforming my query workflow with usql and jq
lorransr profile

From GUI to CLI: Transforming my query workflow with usql and jq

#sql #productivity #vim
2
Comments 1
3 min read
Inside SQL Joins
balajisasikumar profile

Inside SQL Joins

#sql #database #mysql #development
2
Comments
4 min read
Populating a table in PostgreSQL with one million records of random data.
dm8ry profile

Populating a table in PostgreSQL with one million records of random data.

#postgres #database #sql #tutorial
2
Comments
1 min read
The main methods of joining tables in PostgreSQL.
dm8ry profile

The main methods of joining tables in PostgreSQL.

#database #postgres #sql #tutorial
Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL
dm8ry profile

The ARRAY_TO_STRING() function in PostgreSQL

#postgres #database #sql #tutorial
Comments
2 min read
More foreign-key joins
esproc_spl profile

More foreign-key joins

#sql #join #development #opensource
6
Comments
5 min read
Oracle SQL vs MySQL: A Comprehensive Comparison
nikhilxd profile

Oracle SQL vs MySQL: A Comprehensive Comparison

#sql #database #mysql #learning
2
Comments
3 min read
Mastering Oracle SQL Interview Questions: Tips and Answers
nikhilxd profile

Mastering Oracle SQL Interview Questions: Tips and Answers

#sql #oracle #plsql #interview
2
Comments
2 min read
Multi-Tenant SaaS Architecture - Database Per Tenant
developerpartners profile

Multi-Tenant SaaS Architecture - Database Per Tenant

#dotnet #saas #csharp #sql
3
Comments 1
6 min read
Crash on clock skew: performance vs availability
franckpachot profile

Crash on clock skew: performance vs availability

#yugabytedb #distributed #sql #database
2
Comments
7 min read
Fetching Data (Next.js)
samuellubliner profile

Fetching Data (Next.js)

#webdev #javascript #sql #nextjs
1
Comments
2 min read
Foreign-key pre-join
esproc_spl profile

Foreign-key pre-join

#sql #join #development #lauguage
6
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.