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.
Flyway & Azure DevOps : Rodando Flyway Localmente

Flyway & Azure DevOps : Rodando Flyway Localmente

1
Comments 2
2 min read
Flyway & Azure DevOps : Azure SQL Database

Flyway & Azure DevOps : Azure SQL Database

6
Comments 1
3 min read
Flyway & Azure DevOps : IaC com ARM Template

Flyway & Azure DevOps : IaC com ARM Template

3
Comments
4 min read
Python Basics on Hackerrank

Python Basics on Hackerrank

3
Comments
1 min read
Flyway & Azure DevOps : Conhecendo o Flyway

Flyway & Azure DevOps : Conhecendo o Flyway

4
Comments
6 min read
How To Write Better SQL: Advanced SQL Episode 1

How To Write Better SQL: Advanced SQL Episode 1

63
Comments 1
5 min read
Comparing SQL and NoSQL Databases

Comparing SQL and NoSQL Databases

6
Comments
5 min read
sending SQL results periodically to slack

sending SQL results periodically to slack

5
Comments
2 min read
Using Postgres FOR loop to generate data

Using Postgres FOR loop to generate data

14
Comments 1
2 min read
What Is Data Virtualization And Why Use It?

What Is Data Virtualization And Why Use It?

31
Comments 4
7 min read
How to run a long lasting query without interruption?

How to run a long lasting query without interruption?

4
Comments 5
1 min read
Escape SQL LIKE wildcard characters

Escape SQL LIKE wildcard characters

5
Comments
1 min read
My first endeavor with Django...

My first endeavor with Django...

4
Comments
1 min read
How to build jdbc url to Google SQL instance?

How to build jdbc url to Google SQL instance?

7
Comments
1 min read
What Happens When you Put Your SQL Database on the Internet

What Happens When you Put Your SQL Database on the Internet

2
Comments 1
7 min read
Performance and N+1 Queries: Explained, Spotted, and Solved

Performance and N+1 Queries: Explained, Spotted, and Solved

22
Comments
5 min read
Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

78
Comments 26
5 min read
When to decide for NoSQL or SQL?

When to decide for NoSQL or SQL?

6
Comments
6 min read
Automating Data Extractions From Google Sheets With Python

Automating Data Extractions From Google Sheets With Python

58
Comments 4
7 min read
How to: Scrape Facebook Groups for Apartment Rentals

How to: Scrape Facebook Groups for Apartment Rentals

14
Comments 1
3 min read
Rails Migration

Rails Migration

7
Comments
11 min read
Forward and Inverted Indexes - Requirement based differences

Forward and Inverted Indexes - Requirement based differences

10
Comments 1
4 min read
PostgreSQL: Rename database

PostgreSQL: Rename database

5
Comments 2
2 min read
Versioning a Relational Data Model

Versioning a Relational Data Model

7
Comments 2
3 min read
Transaction savepoints in Spring JDBC

Transaction savepoints in Spring JDBC

8
Comments
6 min read
Dead rows in a materialized view

Dead rows in a materialized view

23
Comments
4 min read
Node JS: How to access MySQL remotely using SSH.

Node JS: How to access MySQL remotely using SSH.

10
Comments 1
2 min read
Relational vs NoSQL databases

Relational vs NoSQL databases

24
Comments 9
1 min read
Add new columns to table in PostgreSQL

Add new columns to table in PostgreSQL

9
Comments
1 min read
Database performance: If you're not first, you're last!

Database performance: If you're not first, you're last!

16
Comments
24 min read
Connecting Pandas to a Database with SQLAlchemy

Connecting Pandas to a Database with SQLAlchemy

12
Comments
8 min read
Super Graph - turn GraphQL queries into a single SQL query

Super Graph - turn GraphQL queries into a single SQL query

16
Comments
2 min read
Postgres Table Partitioning

Postgres Table Partitioning

7
Comments
4 min read
AlaSQL in Action: The JavaScript SQL Database

AlaSQL in Action: The JavaScript SQL Database

71
Comments
3 min read
The SQL databases vs NoSQL databases [Difference]

The SQL databases vs NoSQL databases [Difference]

2
Comments
1 min read
Install LEMP Stack (Linux, Nginx, MySQL, PHP) on Ubuntu 18.04 AWS EC2 Instance

Install LEMP Stack (Linux, Nginx, MySQL, PHP) on Ubuntu 18.04 AWS EC2 Instance

7
Comments
1 min read
MySQL Bulk Insert taking long time

MySQL Bulk Insert taking long time

3
Comments
2 min read
I'm in a book! Ha!

I'm in a book! Ha!

5
Comments
1 min read
Unit Test em Stored Procedures (Sql Server) Parte I

Unit Test em Stored Procedures (Sql Server) Parte I

3
Comments
4 min read
Sql Joins

Sql Joins

9
Comments 2
1 min read
Laravel SQL Debugging

Laravel SQL Debugging

11
Comments
1 min read
Day 3: #100DaysofCode - Oh No, SQL

Day 3: #100DaysofCode - Oh No, SQL

6
Comments
3 min read
SQL Queries to Complex JSON Objects

SQL Queries to Complex JSON Objects

33
Comments 1
6 min read
Defensive SQL Query Writing

Defensive SQL Query Writing

3
Comments 2
2 min read
Working with SQLite in Python

Working with SQLite in Python

16
Comments
3 min read
Seed your SqlServer, PostgreSql and MySql databases with CSV files using yuniql migrations

Seed your SqlServer, PostgreSql and MySql databases with CSV files using yuniql migrations

9
Comments
5 min read
List of SQL Commands Glossary of commonly used SQL commands.

List of SQL Commands Glossary of commonly used SQL commands.

15
Comments
4 min read
Recognization Facial Expression and recommending Movies and Songs

Recognization Facial Expression and recommending Movies and Songs

5
Comments
1 min read
Complete Data Engineer's Vocabulary

Complete Data Engineer's Vocabulary

2
Comments
1 min read
How we made our SQL database QuestDB even faster and more accurate

How we made our SQL database QuestDB even faster and more accurate

16
Comments 3
1 min read
Discussion: How to find top n users with five recent posts

Discussion: How to find top n users with five recent posts

13
Comments 4
1 min read
Search Text in stored procedure in SQL Server

Search Text in stored procedure in SQL Server

2
Comments
1 min read
SQL vs NoSQL vs both options for Web projects?

SQL vs NoSQL vs both options for Web projects?

3
Comments
1 min read
Tech Stack to Build Marketplaces like Airbnb

Tech Stack to Build Marketplaces like Airbnb

4
Comments 1
3 min read
Journey To Full Stack: The Schema Of Things

Journey To Full Stack: The Schema Of Things

25
Comments
4 min read
Database Design Tutorial

Database Design Tutorial

158
Comments 2
9 min read
Customizable database-based reporting

Customizable database-based reporting

6
Comments
2 min read
Identity Graph and Identity Resolution in SQL

Identity Graph and Identity Resolution in SQL

6
Comments
7 min read
PyMySQL connector

PyMySQL connector

4
Comments
1 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

94
Comments 4
7 min read
loading...