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 : IaC com ARM Template
Cover image for Flyway & Azure DevOps : IaC com ARM Template

Flyway & Azure DevOps : IaC com ARM Template

3
Comments
4 min read
Python Basics on Hackerrank
Cover image for Python Basics on Hackerrank

Python Basics on Hackerrank

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

Flyway & Azure DevOps : Conhecendo o Flyway

6
Comments
6 min read
How To Write Better SQL: Advanced SQL Episode 1
Cover image for 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
Cover image for 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

19
Comments 1
2 min read
What Is Data Virtualization And Why Use It?
Cover image for What Is Data Virtualization And Why Use It?

What Is Data Virtualization And Why Use It?

31
Comments 4
7 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
How to run a long lasting query without interruption?
Cover image for 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?

8
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
When to decide for NoSQL or SQL?
Cover image for 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
Cover image for Automating Data Extractions From Google Sheets With Python

Automating Data Extractions From Google Sheets With Python

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

How to: Scrape Facebook Groups for Apartment Rentals

17
Comments 1
3 min read
Rails Migration
Cover image for Rails Migration

Rails Migration

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

Forward and Inverted Indexes - Requirement based differences

11
Comments 1
4 min read
PostgreSQL: Rename database
Cover image for PostgreSQL: Rename database

PostgreSQL: Rename database

5
Comments 2
2 min read
[Easy]: Truncate a table and restart Sequences (Identity and cascade)
Cover image for [Easy]: Truncate a table and restart Sequences (Identity and cascade)

[Easy]: Truncate a table and restart Sequences (Identity and cascade)

2
Comments
1 min read
Versioning a Relational Data Model
Cover image for 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
Cover image for Dead rows in a materialized view

Dead rows in a materialized view

23
Comments
4 min read
loading...