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

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

Two free tools to format SQL queries

8
Comments
3 min read
Lakers < ActiveRecord::Base

Lakers < ActiveRecord::Base

26
Comments 9
9 min read
Se conectando ao PostgreSQL usando Golang

Se conectando ao PostgreSQL usando Golang

18
Comments 4
11 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

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

4
Comments
5 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
ORA-29283 hello world

ORA-29283 hello world

2
Comments
2 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!

15
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

7
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

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

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

SQL Join

8
Comments 1
3 min read
Django ORM Optimization Tips #2 prefetch_related

Django ORM Optimization Tips #2 prefetch_related

11
Comments 1
2 min read
Relative calculations 1: LAG and LEAD

Relative calculations 1: LAG and LEAD

4
Comments
5 min read
Django ORM Optimization Tips #1 select_related

Django ORM Optimization Tips #1 select_related

11
Comments 2
1 min read
Node.js with SQLite

Node.js with SQLite

8
Comments 3
3 min read
Node js Left Join with limit and offset Mysql

Node js Left Join with limit and offset Mysql

4
Comments
1 min read
7 rules for designing your first database schema or data model

7 rules for designing your first database schema or data model

18
Comments 4
3 min read
TodoMVC Full Stack with Azure Static WebApps, Node and Azure SQL

TodoMVC Full Stack with Azure Static WebApps, Node and Azure SQL

23
Comments
9 min read
Beginner's guide to using MySQL database in a Node.js app

Beginner's guide to using MySQL database in a Node.js app

81
Comments 7
29 min read
loading...