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.
Amazon RDS Proxy makes it easier to use SQL in Serverless

Amazon RDS Proxy makes it easier to use SQL in Serverless

5
Comments 1
4 min read
Bun: SQL-first Golang ORM

Bun: SQL-first Golang ORM

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

Recover your Dropped Table from the Recyclebin ⛅😎

3
Comments
1 min read
How To Join Data in MongoDB

How To Join Data in MongoDB

5
Comments
6 min read
Database constraints considered harmful?

Database constraints considered harmful?

31
Comments 23
3 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
Creating trigger functions with Supabase

Creating trigger functions with Supabase

18
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

5
Comments
2 min read
Building an application with Go and SQLite

Building an application with Go and SQLite

43
Comments
13 min read
Hibernate - N+1 Problem

Hibernate - N+1 Problem

16
Comments
2 min read
Hibernate - LazyInitializationException

Hibernate - LazyInitializationException

8
Comments
2 min read
Machine Learning for SQL: train, deploy, score your models using SQL...😍

Machine Learning for SQL: train, deploy, score your models using SQL...😍

6
Comments
2 min read
Multi-level Aggregation Using MySQL GROUP BY WITH ROLLUP - OpenLampTech Repost

Multi-level Aggregation Using MySQL GROUP BY WITH ROLLUP - OpenLampTech Repost

3
Comments
1 min read
What are your top SQL tips?

What are your top SQL tips?

11
Comments 14
1 min read
Reusable SQL templates: learn about SQL Macros🤯

Reusable SQL templates: learn about SQL Macros🤯

6
Comments
2 min read
SQLite - Acessando seu banco diretamente do VSCode

SQLite - Acessando seu banco diretamente do VSCode

26
Comments
3 min read
Smart list of values in SQL with LISTAGG

Smart list of values in SQL with LISTAGG

4
Comments
1 min read
SQL Using AS Operator

SQL Using AS Operator

7
Comments
3 min read
Immutable File Storage

Immutable File Storage

20
Comments
3 min read
A List of PostgreSQL Commands for Beginners

A List of PostgreSQL Commands for Beginners

5
Comments
4 min read
Optimizing Active Record queries

Optimizing Active Record queries

42
Comments 1
11 min read
PL/SQL functions defined in SQL queries🤯

PL/SQL functions defined in SQL queries🤯

2
Comments
1 min read
Optimización de queries en Rails

Optimización de queries en Rails

20
Comments 1
12 min read
How to insert random data for testing in PostgreSQL?

How to insert random data for testing in PostgreSQL?

13
Comments
2 min read
Using Materialize and Airbyte with MySQL and Redpanda/Kafka

Using Materialize and Airbyte with MySQL and Redpanda/Kafka

9
Comments
5 min read
Database Indexes, please be careful when using it!

Database Indexes, please be careful when using it!

7
Comments 2
2 min read
Difference of the handling the spaces between Oracle and SQL Server

Difference of the handling the spaces between Oracle and SQL Server

5
Comments
2 min read
SQL-Quick tip #7 - Find stored procedures

SQL-Quick tip #7 - Find stored procedures

10
Comments
1 min read
Index Skip Scan in YugabyteDB 🚀🐘

Index Skip Scan in YugabyteDB 🚀🐘

7
Comments
12 min read
😈 Let's run deadlock manually ! [SQL]

😈 Let's run deadlock manually ! [SQL]

6
Comments
1 min read
🤹‍♀️ SELECT ORDER [SQL]

🤹‍♀️ SELECT ORDER [SQL]

6
Comments
1 min read
🤠 Group by, Having, Join, View, Sub query, Scala sub query, Case [SQL]

🤠 Group by, Having, Join, View, Sub query, Scala sub query, Case [SQL]

3
Comments
3 min read
🤨 What is N+1 problem?

🤨 What is N+1 problem?

5
Comments
1 min read
🤔 What is Database Index?

🤔 What is Database Index?

7
Comments
2 min read
[ Database ] - SQLAlchemy "or_" function

[ Database ] - SQLAlchemy "or_" function

7
Comments
1 min read
Taming PgAdmin's SQL Formatting

Taming PgAdmin's SQL Formatting

4
Comments
2 min read
Data Platforms Vs Data Warehouses Vs Data Virtualization And Federated SQL Engine

Data Platforms Vs Data Warehouses Vs Data Virtualization And Federated SQL Engine

12
Comments
5 min read
Insert CSV Rows into a Database Using Vanilla Ruby

Insert CSV Rows into a Database Using Vanilla Ruby

10
Comments
6 min read
How To Choose An Efficient Storage For Data.

How To Choose An Efficient Storage For Data.

4
Comments
2 min read
Git-How to publish git pages.

Git-How to publish git pages.

7
Comments
1 min read
SQL-Quick tip #6 - Find table or column

SQL-Quick tip #6 - Find table or column

6
Comments
2 min read
Utilizando views SQL no Ruby on Rails

Utilizando views SQL no Ruby on Rails

18
Comments
9 min read
The One Query Performance Trick You NEED to Know? Tune Table!

The One Query Performance Trick You NEED to Know? Tune Table!

6
Comments
9 min read
SQL Select Query

SQL Select Query

6
Comments
1 min read
Python Django `dbshell`

Python Django `dbshell`

14
Comments 3
1 min read
SQL UPDATE and DELETE Commands

SQL UPDATE and DELETE Commands

7
Comments
2 min read
[ Database ] - Session Object of SQLAlchemy

[ Database ] - Session Object of SQLAlchemy

5
Comments
1 min read
Top 10 Manual Testing Interview Questions

Top 10 Manual Testing Interview Questions

4
Comments
2 min read
Using an Array of strings in a query with Oracle PL/SQL

Using an Array of strings in a query with Oracle PL/SQL

9
Comments
1 min read
SQL INSERT Command

SQL INSERT Command

5
Comments
2 min read
Coding a database and UI that allows students to share books on a website.

Coding a database and UI that allows students to share books on a website.

4
Comments
1 min read
SQL-Quick tip #5 - Create a sequence of date and time

SQL-Quick tip #5 - Create a sequence of date and time

18
Comments
1 min read
Usando transaction no knex

Usando transaction no knex

6
Comments
1 min read
SQL-Quick tip #2 - Randomize rows

SQL-Quick tip #2 - Randomize rows

5
Comments
1 min read
SQL DDL Commands

SQL DDL Commands

3
Comments
6 min read
Stalactite ORM 1.0.0 is out !

Stalactite ORM 1.0.0 is out !

7
Comments
1 min read
loading...