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.
How to use Change Data Capture (CDC) with Postgres

How to use Change Data Capture (CDC) with Postgres

22
Comments 4
3 min read
What have the STORED PROCEDURES ever done for us?

What have the STORED PROCEDURES ever done for us?

14
Comments 6
4 min read
Adventures in SQL Source Control with SSDT

Adventures in SQL Source Control with SSDT

13
Comments 2
7 min read
Coding Bootcamp - Backend #3 - Databases, SQL, and knex

Coding Bootcamp - Backend #3 - Databases, SQL, and knex

6
Comments
5 min read
T-SQL CRUD procedures auto-generator

T-SQL CRUD procedures auto-generator

39
Comments 2
4 min read
First steps to caching PostgreSQL queries with Redis

First steps to caching PostgreSQL queries with Redis

57
Comments
5 min read
The Best MYSQL Courses for Beginners

The Best MYSQL Courses for Beginners

12
Comments
5 min read
Using the IFS variable to do things with CSV files

Using the IFS variable to do things with CSV files

5
Comments
5 min read
Optimize multiple INSERTs (for Oracle)

Optimize multiple INSERTs (for Oracle)

7
Comments 4
3 min read
How to Synchronize relational databases with Dotmim.Sync

How to Synchronize relational databases with Dotmim.Sync

22
Comments 5
5 min read
User management for Node.js & MySQL using Sequelize and PassportJS

User management for Node.js & MySQL using Sequelize and PassportJS

35
Comments 6
8 min read
API data persistence with relational databases

API data persistence with relational databases

10
Comments
3 min read
SQL Story of unbroken chains of events (daily/weekly streaks)

SQL Story of unbroken chains of events (daily/weekly streaks)

21
Comments 2
7 min read
Introduction to Profiling and Optimizing SQL Queries for Software Engineers

Introduction to Profiling and Optimizing SQL Queries for Software Engineers

14
Comments 2
11 min read
Complete MySQL Course: Beginner to Advanced

Complete MySQL Course: Beginner to Advanced

30
Comments
1 min read
Notes on Migrating from MS SQL Server to PostgreSQL

Notes on Migrating from MS SQL Server to PostgreSQL

9
Comments
8 min read
API data persistence with relational databases

API data persistence with relational databases

6
Comments
2 min read
The Wild SQL Query I Wrote For Work This Week

The Wild SQL Query I Wrote For Work This Week

61
Comments 1
7 min read
Intro to SQL User Defined Functions (UDFs) in Redshift

Intro to SQL User Defined Functions (UDFs) in Redshift

8
Comments
5 min read
How can I stop a PostgreSQL query automatically when the table is locked?

How can I stop a PostgreSQL query automatically when the table is locked?

5
Comments 2
1 min read
Access Google BigQuery Data with Entity Framework 6

Access Google BigQuery Data with Entity Framework 6

7
Comments
3 min read
API data persistence

API data persistence

9
Comments
3 min read
Best way to store array type data inside database?

Best way to store array type data inside database?

30
Comments 22
1 min read
Free SQL hosting providers ?

Free SQL hosting providers ?

27
Comments 23
1 min read
🤔 How to create a MySQL connection and run queries with Python3

🤔 How to create a MySQL connection and run queries with Python3

13
Comments 1
1 min read
Good sources (courses, books, sites) on database design and data modeling?

Good sources (courses, books, sites) on database design and data modeling?

14
Comments 2
1 min read
SQL Conceitos Básicos. Postgres + Docker

SQL Conceitos Básicos. Postgres + Docker

12
Comments
10 min read
Database generic way of achieving Query Result Change Notification

Database generic way of achieving Query Result Change Notification

7
Comments 1
1 min read
SMSS -'Connect to Server' Hell

SMSS -'Connect to Server' Hell

6
Comments
1 min read
Basic DB Using SQL Server (Part 3) - retrieve data using SQL

Basic DB Using SQL Server (Part 3) - retrieve data using SQL

11
Comments
6 min read
Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

8
Comments
8 min read
Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core

Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core

15
Comments
5 min read
Documenting SQL with Markdown and Diagrams

Documenting SQL with Markdown and Diagrams

24
Comments 5
2 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
Setting up an ASP.NET Core Restaurant Website with a Vue.js Online Ordering Page.

Setting up an ASP.NET Core Restaurant Website with a Vue.js Online Ordering Page.

10
Comments 1
4 min read
A plea for blogging about SQL

A plea for blogging about SQL

8
Comments 1
2 min read
How to organize dynamic attributes/properties of products specification?

How to organize dynamic attributes/properties of products specification?

6
Comments 2
1 min read
C#: Data Access Batch Execution is now very simple with RepoDb ORM

C#: Data Access Batch Execution is now very simple with RepoDb ORM

32
Comments 2
5 min read
Index Overview

Index Overview

17
Comments
4 min read
RDBMS or NoSQL: The question that pops up with every new project!

RDBMS or NoSQL: The question that pops up with every new project!

13
Comments 8
2 min read
How To Use Postgres With Knex On Your Node API

How To Use Postgres With Knex On Your Node API

13
Comments
2 min read
Coding Bootcamp - Backend #1 - Asynchronous code

Coding Bootcamp - Backend #1 - Asynchronous code

34
Comments 2
1 min read
Laravel, Lumen dockerization

Laravel, Lumen dockerization

7
Comments
1 min read
SQL Join Memento

SQL Join Memento

6
Comments
3 min read
Query NetSuite Data through ODBC in Node.js

Query NetSuite Data through ODBC in Node.js

9
Comments 3
3 min read
Sinatra Web App: MVC, Sessions, and Routes

Sinatra Web App: MVC, Sessions, and Routes

9
Comments
4 min read
SQL API for Real-Time Kafka Analytics in 3 Steps

SQL API for Real-Time Kafka Analytics in 3 Steps

6
Comments
8 min read
Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

49
Comments 11
5 min read
Exterminate! 🤖 (or Destroying Associated Records in Rails)

Exterminate! 🤖 (or Destroying Associated Records in Rails)

24
Comments 5
4 min read
The best free courses to learn about Databases and SQL for Beginners

The best free courses to learn about Databases and SQL for Beginners

38
Comments
4 min read
♻️🐘 Disposable local Postgres databases (without containers!)

♻️🐘 Disposable local Postgres databases (without containers!)

22
Comments
6 min read
Writing SQL for humans with Literate SQL

Writing SQL for humans with Literate SQL

46
Comments 4
7 min read
Working with JSON in an RDBMS – Part 2, PostgreSQL

Working with JSON in an RDBMS – Part 2, PostgreSQL

8
Comments
9 min read
Connect to postgresdatabase with JAVA

Connect to postgresdatabase with JAVA

4
Comments
1 min read
Programming Paradigm

Programming Paradigm

85
Comments 9
4 min read
Hierarchical JSON with SQLite / RediSQL

Hierarchical JSON with SQLite / RediSQL

9
Comments
4 min read
Connect your node backend to postgresql database

Connect your node backend to postgresql database

3
Comments
1 min read
Remove duplicates rows with SQL

Remove duplicates rows with SQL

10
Comments
1 min read
Paradigmas de Programação

Paradigmas de Programação

19
Comments 3
4 min read
SQL Indexes 101

SQL Indexes 101

19
Comments
3 min read
loading...