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.
First impressions of PopSQL’s collaborative SQL editor

First impressions of PopSQL’s collaborative SQL editor

44
Comments 1
4 min read
Getting to know SQL Server Extended Events

Getting to know SQL Server Extended Events

26
Comments
7 min read
Code-First ORM For Go: GORM

Code-First ORM For Go: GORM

9
Comments
3 min read
Distributed SQL Tips and Tricks – Aug 17, 2020

Distributed SQL Tips and Tricks – Aug 17, 2020

2
Comments
4 min read
SQL Cheatsheet - Most Common Commands

SQL Cheatsheet - Most Common Commands

18
Comments 1
13 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Don't ever use LIMIT again!!!

Don't ever use LIMIT again!!!

6
Comments 1
5 min read
Convince me to use SQL

Convince me to use SQL

29
Comments 17
1 min read
Alembic: setting a column to nullable=False if it already has data in it

Alembic: setting a column to nullable=False if it already has data in it

6
Comments 1
2 min read
Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

48
Comments 1
7 min read
Azure SQL for Beginners - Video Playlist

Azure SQL for Beginners - Video Playlist

28
Comments
1 min read
SQL Server Profiler, underused and undervalued

SQL Server Profiler, underused and undervalued

8
Comments
5 min read
Why SQLite is simple to use!

Why SQLite is simple to use!

6
Comments 2
2 min read
DataGrip: Exporting Data as SQL Batch Inserts (and more)

DataGrip: Exporting Data as SQL Batch Inserts (and more)

8
Comments
2 min read
Version Control for Distributed SQL Databases with Flyway

Version Control for Distributed SQL Databases with Flyway

3
Comments
6 min read
Should I Take the Data Engineer Nano Degree?

Should I Take the Data Engineer Nano Degree?

4
Comments 2
3 min read
Django Same data objects get created every time!

Django Same data objects get created every time!

3
Comments 1
2 min read
4 SQL Tips For Data Scientists And Data Analysts

4 SQL Tips For Data Scientists And Data Analysts

91
Comments 4
7 min read
Banco de dados relacional - Introdução

Banco de dados relacional - Introdução

8
Comments
3 min read
Hidden Gems: Event-Driven Change Notifications in Relational Databases

Hidden Gems: Event-Driven Change Notifications in Relational Databases

6
Comments
10 min read
A Case Study of Date and Time

A Case Study of Date and Time

3
Comments 1
6 min read
High Performance Database Access with EF Core

High Performance Database Access with EF Core

22
Comments 1
1 min read
WSFC + SQL AlwaysOn no AZURE sem Active Directory [#3]

WSFC + SQL AlwaysOn no AZURE sem Active Directory [#3]

3
Comments
9 min read
WSFC + SQL AlwaysOn no AZURE sem Active Directory [#1]

WSFC + SQL AlwaysOn no AZURE sem Active Directory [#1]

4
Comments
6 min read
Sqlmancer - translate GraphQL queries into SQL statements

Sqlmancer - translate GraphQL queries into SQL statements

20
Comments
3 min read
Keep your Code and Database in Sync

Keep your Code and Database in Sync

32
Comments 1
1 min read
PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

6
Comments 1
13 min read
Database design

Database design

65
Comments 4
4 min read
Codecadmey Data Science Course Part IV

Codecadmey Data Science Course Part IV

4
Comments 2
6 min read
How to Install Oracle SQL Developer on Ubuntu 20.04

How to Install Oracle SQL Developer on Ubuntu 20.04

110
Comments 36
4 min read
Python JDBC connection into IRIS database - a quick note

Python JDBC connection into IRIS database - a quick note

4
Comments
9 min read
Qué son las bases de datos orientadas a grafos y para qué se usan

Qué son las bases de datos orientadas a grafos y para qué se usan

8
Comments
4 min read
Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!*

Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!*

3
Comments
4 min read
Codecademy Data Science Course Part III

Codecademy Data Science Course Part III

3
Comments
2 min read
Flask Login-Register-Logout Implementation

Flask Login-Register-Logout Implementation

25
Comments 6
7 min read
Passed the test, next class that covers Psudo Programing [WGU basics]

Passed the test, next class that covers Psudo Programing [WGU basics]

2
Comments
1 min read
Codecademy Data Science Course Part II

Codecademy Data Science Course Part II

3
Comments
3 min read
Codecademy Data Science Course Part I

Codecademy Data Science Course Part I

4
Comments 3
2 min read
Dica Rápida: Paginando no MSSQL considerando escala

Dica Rápida: Paginando no MSSQL considerando escala

8
Comments 7
2 min read
Azure Data Studio Custom Theme

Azure Data Studio Custom Theme

7
Comments
3 min read
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
What is a relational database and relational database management system?

What is a relational database and relational database management system?

32
Comments
2 min read
Databases and MySQL

Databases and MySQL

7
Comments
4 min read
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

SQL Knowledge 101

5
Comments
4 min read
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

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

9
Comments
4 min read
HarperDB: A NewSQL Database.

HarperDB: A NewSQL Database.

38
Comments 1
5 min read
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?

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

How to Query a JSON in PostgreSQL

8
Comments
3 min read
Multiplatform Encryption with SQLDelight and SQLCipher

Multiplatform Encryption with SQLDelight and SQLCipher

19
Comments
3 min read
loading...