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.
Cliff - The rust DBMS

Cliff - The rust DBMS

6
Comments 2
1 min read
DuckDB: an embedded DB for data wrangling

DuckDB: an embedded DB for data wrangling

2
Comments
3 min read
Connect the DataBase | SQLite-Python Series

Connect the DataBase | SQLite-Python Series

10
Comments 2
2 min read
Sinatra CRUD MVC Project

Sinatra CRUD MVC Project

3
Comments
2 min read
How and When to Use SQL Window Functions

How and When to Use SQL Window Functions

7
Comments
2 min read
MySQL or MongoDB? What to Choose for your Next Project?

MySQL or MongoDB? What to Choose for your Next Project?

41
Comments 13
2 min read
Rails 6.1 supports order DESC for find_each, find_in_batches, and in_batches

Rails 6.1 supports order DESC for find_each, find_in_batches, and in_batches

4
Comments
1 min read
How to Install MySQL Workbench On Windows

How to Install MySQL Workbench On Windows

15
Comments 1
3 min read
Kubernetes: running SQL migrations with Kubernetes Job and Helm hook

Kubernetes: running SQL migrations with Kubernetes Job and Helm hook

13
Comments
11 min read
How to Backup and Restore SQL Database from One Server to Another Server

How to Backup and Restore SQL Database from One Server to Another Server

4
Comments
3 min read
XAMPP Installation Step By Step on MacOs

XAMPP Installation Step By Step on MacOs

11
Comments 3
2 min read
SQL Query Inner Join for SUM Amount

SQL Query Inner Join for SUM Amount

6
Comments 1
3 min read
QuestDB announces Grafana support

QuestDB announces Grafana support

7
Comments
1 min read
Beginners guide to Integrating Python and SQL

Beginners guide to Integrating Python and SQL

27
Comments 1
4 min read
DynamicODataToSQL : dotnet OData to SQL query converter

DynamicODataToSQL : dotnet OData to SQL query converter

2
Comments
1 min read
A new TypeScript Postgres query builder

A new TypeScript Postgres query builder

9
Comments
4 min read
Simple CRUD REST API With Lumen + MySQL + Eloquent ORM

Simple CRUD REST API With Lumen + MySQL + Eloquent ORM

32
Comments 3
8 min read
#003 How to run SQL server on ubuntu; how to (re)start SQL server on ubuntu; how to stop SQL server on ubuntu

#003 How to run SQL server on ubuntu; how to (re)start SQL server on ubuntu; how to stop SQL server on ubuntu

3
Comments 1
1 min read
How to Drop All Tables in PostgreSQL Database

How to Drop All Tables in PostgreSQL Database

5
Comments
4 min read
Two free tools to format SQL queries

Two free tools to format SQL queries

12
Comments
3 min read
Lakers < ActiveRecord::Base

Lakers < ActiveRecord::Base

26
Comments 9
9 min read
3 Things I wish I knew about databases two years ago

3 Things I wish I knew about databases two years ago

5
Comments
3 min read
SQL or NoSQL?

SQL or NoSQL?

8
Comments 6
1 min read
How to build a Data Pipeline for the first time

How to build a Data Pipeline for the first time

74
Comments 10
5 min read
Optimizing your GraphQL API with Postgres

Optimizing your GraphQL API with Postgres

6
Comments
7 min read
Sqlite 3 - Python Database

Sqlite 3 - Python Database

7
Comments
2 min read
Full-Stack Sapper & SQLite with Sequelize Pt.1

Full-Stack Sapper & SQLite with Sequelize Pt.1

7
Comments 2
4 min read
SQL? NoSQL? What's the Difference?

SQL? NoSQL? What's the Difference?

7
Comments
4 min read
ACID

ACID

5
Comments
3 min read
How to decrypt hash password

How to decrypt hash password

5
Comments 7
1 min read
Geospatial Data: A New Dimension for .NET

Geospatial Data: A New Dimension for .NET

5
Comments
1 min read
What is the Difference between SQL and NoSQL Database?

What is the Difference between SQL and NoSQL Database?

5
Comments 2
1 min read
SQL and Relational Databases Explained (By a Non-Developer)

SQL and Relational Databases Explained (By a Non-Developer)

62
Comments 4
7 min read
What is SQL?

What is SQL?

2
Comments
2 min read
What is Database?

What is Database?

2
Comments
1 min read
SQL Vs Oracle – Which One Is Better?

SQL Vs Oracle – Which One Is Better?

3
Comments
4 min read
Experiences with coding (SQL based DBs)

Experiences with coding (SQL based DBs)

1
Comments
3 min read
Never Trust User Input

Never Trust User Input

6
Comments 4
3 min read
Database Normalisation (1st-4th N.F.) using an example

Database Normalisation (1st-4th N.F.) using an example

5
Comments
5 min read
ORA-29283 hello world

ORA-29283 hello world

2
Comments
2 min read
Anonymous PL/SQL to write a CSV from SQL

Anonymous PL/SQL to write a CSV from SQL

2
Comments
3 min read
Top 10 SQL Queries to Prepare for Interviews

Top 10 SQL Queries to Prepare for Interviews

16
Comments
3 min read
What exactly does Indexing in a Database do?

What exactly does Indexing in a Database do?

114
Comments 4
2 min read
Let's stop being stupid about security

Let's stop being stupid about security

5
Comments
4 min read
Top Trends in Web Development in 2021

Top Trends in Web Development in 2021

36
Comments 4
3 min read
Promises, Node, Tedious, Azure SQL. Oh My!

Promises, Node, Tedious, Azure SQL. Oh My!

16
Comments
4 min read
How to see a history of queries ran on a SQL server

How to see a history of queries ran on a SQL server

16
Comments 2
2 min read
How to Send a Complex Type List of Objects to SQL Server

How to Send a Complex Type List of Objects to SQL Server

11
Comments 3
5 min read
MySQL

MySQL

4
Comments 4
1 min read
Django ORM Optimization Tips #4 recursive query

Django ORM Optimization Tips #4 recursive query

34
Comments
2 min read
A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

4
Comments
5 min read
Set up Extended Events in SQL Server

Set up Extended Events in SQL Server

3
Comments 1
5 min read
Introduction to full-text operators and basic search

Introduction to full-text operators and basic search

7
Comments 2
10 min read
Analyzing Data Without Complicated ETLs For Data Scientists

Analyzing Data Without Complicated ETLs For Data Scientists

27
Comments
6 min read
The best way to synchronize (one way) a table in SQL Server

The best way to synchronize (one way) a table in SQL Server

8
Comments
4 min read
Running SQL Migrations Before Booting Docker Compose Services

Running SQL Migrations Before Booting Docker Compose Services

12
Comments
4 min read
Getting Started with IntelliJ IDEA and Distributed SQL

Getting Started with IntelliJ IDEA and Distributed SQL

5
Comments
6 min read
DynamoDB or PostgreSQL???

DynamoDB or PostgreSQL???

4
Comments 1
1 min read
Don't store null bits

Don't store null bits

7
Comments
4 min read
N + What? (Or: a brief introduction to n + 1 queries and how to avoid them)

N + What? (Or: a brief introduction to n + 1 queries and how to avoid them)

10
Comments
5 min read
loading...