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.
Top 10 SQL Queries asked in Interviews

Top 10 SQL Queries asked in Interviews

11
Comments 2
3 min read
Connect your Java application with any SQL databases

Connect your Java application with any SQL databases

11
Comments
4 min read
"I want to try it" 🚀 YugabyteDB at KubeCon

"I want to try it" 🚀 YugabyteDB at KubeCon

11
Comments
3 min read
SQL-Quick tip #12 - Available disk space

SQL-Quick tip #12 - Available disk space

7
Comments
2 min read
Think twice before using AGE in PotgreSQL

Think twice before using AGE in PotgreSQL

8
Comments
2 min read
Entity Framework Core Add if not exist

Entity Framework Core Add if not exist

6
Comments
1 min read
How to create a View in SQL Server

How to create a View in SQL Server

10
Comments
9 min read
Modelagem Dimensional

Modelagem Dimensional

1
Comments
2 min read
How does Apache ShardingSphere implement distributed transactions?

How does Apache ShardingSphere implement distributed transactions?

4
Comments
8 min read
SQL: One to Many Join Query in an Optimal way with Node.js

SQL: One to Many Join Query in an Optimal way with Node.js

12
Comments 3
4 min read
Xamarin Android: Create Login Using SQLite Database | iFour Technolab

Xamarin Android: Create Login Using SQLite Database | iFour Technolab

6
Comments
5 min read
🐘OID <-> 🚀table_id

🐘OID <-> 🚀table_id

7
Comments
4 min read
SQL vs. NoSQL

SQL vs. NoSQL

17
Comments 9
2 min read
My Brush with Analytics Engineering

My Brush with Analytics Engineering

6
Comments
5 min read
Workout Programmer

Workout Programmer

10
Comments
6 min read
Amazon RDS Proxy makes it easier to use SQL in Serverless

Amazon RDS Proxy makes it easier to use SQL in Serverless

5
Comments
4 min read
SQL-Quick tip #8 - Finding foreign key constraints

SQL-Quick tip #8 - Finding foreign key constraints

6
Comments
1 min read
SQL Basic - What you need to know! (Basics)

SQL Basic - What you need to know! (Basics)

8
Comments
2 min read
5 Best Public Datasets to Practice Your Data Analysis Skills

5 Best Public Datasets to Practice Your Data Analysis Skills

6
Comments
6 min read
Postgres: Setup & Basics

Postgres: Setup & Basics

5
Comments 2
3 min read
🚀 YugabyteDB on fly.io - I - yugabyted

🚀 YugabyteDB on fly.io - I - yugabyted

14
Comments 1
8 min read
SQL-Quick tip #7 - Find stored procedures

SQL-Quick tip #7 - Find stored procedures

6
Comments
1 min read
How to Use ShardingSphere-Proxy in Real Production Scenarios—Your Quick Start Guide

How to Use ShardingSphere-Proxy in Real Production Scenarios—Your Quick Start Guide

10
Comments
10 min read
SQL-Quick tip #10 - Select table definition

SQL-Quick tip #10 - Select table definition

7
Comments
1 min read
Optimizing database query - In a loop

Optimizing database query - In a loop

9
Comments
2 min read
Lessons learnt from the 8 week sql challenge: window functions & ranking

Lessons learnt from the 8 week sql challenge: window functions & ranking

10
Comments
3 min read
When Disaster Strikes: Production Troubleshooting

When Disaster Strikes: Production Troubleshooting

10
Comments 1
6 min read
MySQL Cheatsheet

MySQL Cheatsheet

10
Comments
8 min read
How Install MySQL and Workbench on Windows

How Install MySQL and Workbench on Windows

5
Comments
3 min read
Instantly query AWS with SQL in CloudShell

Instantly query AWS with SQL in CloudShell

18
Comments
3 min read
SQL-Quick tip #11 - Most intensive queries

SQL-Quick tip #11 - Most intensive queries

10
Comments
2 min read
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)

The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)

6
Comments
4 min read
How to add SQL editor to your django admin.

How to add SQL editor to your django admin.

10
Comments
8 min read
SQL Basic Cheat Sheet

SQL Basic Cheat Sheet

34
Comments 1
3 min read
Optimiza tu aplicación rails utilizando índices en Postgres

Optimiza tu aplicación rails utilizando índices en Postgres

20
Comments 1
13 min read
🐘🚀 Update/Insert/Soft-Delete from a JSON payload

🐘🚀 Update/Insert/Soft-Delete from a JSON payload

6
Comments
4 min read
Read Committed is a must for Postgres-compatible distributed SQL databases

Read Committed is a must for Postgres-compatible distributed SQL databases

10
Comments
7 min read
The complete guide to System Design in 2022

The complete guide to System Design in 2022

42
Comments
27 min read
JMeter Interview Questions

JMeter Interview Questions

5
Comments
2 min read
Install SQL Server command-line tools

Install SQL Server command-line tools

6
Comments
1 min read
Install SQL Server in Ubuntu

Install SQL Server in Ubuntu

9
Comments
1 min read
Database Migration: SQLite to PostgreSQL

Database Migration: SQLite to PostgreSQL

4
Comments
5 min read
SQL Triggers with AWS Lambda — Take Your DB to the Next Level

SQL Triggers with AWS Lambda — Take Your DB to the Next Level

9
Comments
5 min read
Learn sql we must

Learn sql we must

5
Comments
1 min read
Digging into Postgresql and DEV

Digging into Postgresql and DEV

42
Comments 7
3 min read
Generate Django database Models from SQL database (MySQL, PostgreSQL, and More)

Generate Django database Models from SQL database (MySQL, PostgreSQL, and More)

3
Comments
1 min read
How to resolve N+1 problem on Rails

How to resolve N+1 problem on Rails

10
Comments 1
2 min read
Bun: SQL-first Golang ORM

Bun: SQL-first Golang ORM

16
Comments 4
4 min read
Recover your Dropped Table from the Recyclebin ⛅😎

Recover your Dropped Table from the Recyclebin ⛅😎

3
Comments
1 min read
Database constraints considered harmful?

Database constraints considered harmful?

27
Comments 23
3 min read
How To Join Data in MongoDB

How To Join Data in MongoDB

5
Comments
6 min read
SQL-Quick tip #9 - Number of rows in all tables

SQL-Quick tip #9 - Number of rows in all tables

6
Comments
1 min read
Apache ShardingSphere 5.1.1 Is Available

Apache ShardingSphere 5.1.1 Is Available

3
Comments
5 min read
Referential Integrity With Sharded Databases

Referential Integrity With Sharded Databases

13
Comments
7 min read
Stalactite ORM 1.0.0 is out !

Stalactite ORM 1.0.0 is out !

7
Comments
1 min read
Creating trigger functions with Supabase

Creating trigger functions with Supabase

17
Comments 1
2 min read
Filtering Spam Email with MindsDB

Filtering Spam Email with MindsDB

9
Comments
5 min read
Soft delete cascade in PostgreSQL🐘 and YugabyteDB🚀

Soft delete cascade in PostgreSQL🐘 and YugabyteDB🚀

19
Comments
5 min read
UPDATE > MariaDB

UPDATE > MariaDB

4
Comments
1 min read
Hibernate - HQL vs SQL

Hibernate - HQL vs SQL

3
Comments
2 min read
loading...