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.
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

96
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

5
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

23
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
Extracting SQL code from SSIS dtsx packages with Python lxml

Extracting SQL code from SSIS dtsx packages with Python lxml

8
Comments 1
3 min read
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
Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

10
Comments
1 min read
Using MySQL Together With Go

Using MySQL Together With Go

3
Comments
1 min read
Data Architecture as a Utility Tool

Data Architecture as a Utility Tool

5
Comments
10 min read
Limit MySQL subquery results inside a WHERE IN clause, using Laravel's Eloquent ORM

Limit MySQL subquery results inside a WHERE IN clause, using Laravel's Eloquent ORM

12
Comments 1
5 min read
Querying CSV files in AWS S3 from Go, using SQL

Querying CSV files in AWS S3 from Go, using SQL

10
Comments
5 min read
Oracle SQL Analytic Functions - Part 1

Oracle SQL Analytic Functions - Part 1

13
Comments
10 min read
When to use NoSQL over SQL ?

When to use NoSQL over SQL ?

9
Comments 4
2 min read
Algebraic data types in SQL

Algebraic data types in SQL

5
Comments 5
1 min read
1 SQL Query You Should Stop Using

1 SQL Query You Should Stop Using

369
Comments 43
3 min read
5 Trends In Big Data And SQL To Be Excited About In 2020

5 Trends In Big Data And SQL To Be Excited About In 2020

28
Comments
8 min read
Deploy a Full-Stack App on GCP with a Cloud SQL Connection: Part 2

Deploy a Full-Stack App on GCP with a Cloud SQL Connection: Part 2

11
Comments
4 min read
How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs

How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs

43
Comments 1
6 min read
loading...