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.
Azure Data Studio Custom Theme

Azure Data Studio Custom Theme

9
Comments
3 min read
Dica rápida: Paginando no MSSQL com Offset e Fetch
Cover image for Dica rápida: Paginando no MSSQL com Offset e Fetch

Dica rápida: Paginando no MSSQL com Offset e Fetch

8
Comments
2 min read
Master your Database using C# with EF Core 5.0

Master your Database using C# with EF Core 5.0

40
Comments
1 min read
Databases and MySQL

Databases and MySQL

7
Comments
4 min read
MySQL Tutorial: the beginner's guide to using MySQL
Cover image for MySQL Tutorial: the beginner's guide to using MySQL

MySQL Tutorial: the beginner's guide to using MySQL

25
Comments
12 min read
SQL Knowledge 101
Cover image for SQL Knowledge 101

SQL Knowledge 101

5
Comments
4 min read
Advanced SQLAlchemy Features You Need To Start Using
Cover image for Advanced SQLAlchemy Features You Need To Start Using

Advanced SQLAlchemy Features You Need To Start Using

25
Comments
10 min read
A Take on Empowering ActiveRecord
Cover image for A Take on Empowering ActiveRecord

A Take on Empowering ActiveRecord

48
Comments 8
3 min read
Inner Join Tables in SQL

Inner Join Tables in SQL

5
Comments
3 min read
PL/SQL Cheat Sheet

PL/SQL Cheat Sheet

4
Comments
1 min read
LMDB Deep Dive: Interview with a CTO on using the Open Source Key Value Store

LMDB Deep Dive: Interview with a CTO on using the Open Source Key Value Store

29
Comments 1
13 min read
Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

24
Comments 1
30 min read
Efficient INSERT MULTIPLE with Postgres

Efficient INSERT MULTIPLE with Postgres

10
Comments
4 min read
HarperDB: A NewSQL Database.
Cover image for HarperDB: A NewSQL Database.

HarperDB: A NewSQL Database.

38
Comments 1
5 min read
Using SUBSTR and INSTR functions in ORACLE PLSQL
Cover image for Using SUBSTR and INSTR functions in ORACLE PLSQL

Using SUBSTR and INSTR functions in ORACLE PLSQL

4
Comments
1 min read
When to choose NoSQL over SQL?
Cover image for When to choose NoSQL over SQL?

When to choose NoSQL over SQL?

210
Comments 22
2 min read
Why is SQL injection still a thing?

Why is SQL injection still a thing?

4
Comments 1
1 min read
PL/SQL Nested Queries

PL/SQL Nested Queries

8
Comments
5 min read
How to Query a JSON in PostgreSQL
Cover image for How to Query a JSON in PostgreSQL

How to Query a JSON in PostgreSQL

8
Comments
3 min read
Multiplatform Encryption with SQLDelight and SQLCipher
Cover image for Multiplatform Encryption with SQLDelight and SQLCipher

Multiplatform Encryption with SQLDelight and SQLCipher

19
Comments
3 min read
Extracting SQL code from SSIS dtsx packages with Python lxml

Extracting SQL code from SSIS dtsx packages with Python lxml

11
Comments 1
3 min read
Getting started with our PostgreSQL database

Getting started with our PostgreSQL database

8
Comments
4 min read
Snowflake Field Notes
Cover image for Snowflake Field Notes

Snowflake Field Notes

8
Comments
12 min read
clientsdb - A docker image with clients comments

clientsdb - A docker image with clients comments

8
Comments
2 min read
Deep Dive: NewSQL Databases

Deep Dive: NewSQL Databases

69
Comments 3
8 min read
loading...