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

11
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
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
SQL and Relational Databases Explained (By a Non-Developer)

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

61
Comments 4
7 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

14
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

10
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

33
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
IT Staff Augmentation Services- Enhance Your Business Growth With the Top Class Tech Talent

IT Staff Augmentation Services- Enhance Your Business Growth With the Top Class Tech Talent

6
Comments 2
4 min read
What is database indexing and how it works

What is database indexing and how it works

6
Comments 1
2 min read
The Complexity of Active Record Transactions

The Complexity of Active Record Transactions

9
Comments 2
7 min read
Normality for a Flexible World

Normality for a Flexible World

2
Comments
2 min read
Common SQL Injections to Watch Out For

Common SQL Injections to Watch Out For

8
Comments
2 min read
Should I use SQL Views With ORM frameworks?

Should I use SQL Views With ORM frameworks?

3
Comments 1
1 min read
Prevent Hibernate from doing N+1 selects with constructor expression

Prevent Hibernate from doing N+1 selects with constructor expression

2
Comments
6 min read
Vaccines for Common SQL Injection Bugs

Vaccines for Common SQL Injection Bugs

4
Comments
2 min read
Django ORM Optimization Tips #3 aggregation

Django ORM Optimization Tips #3 aggregation

10
Comments 1
3 min read
loading...