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.
Creating trigger functions with Supabase

Creating trigger functions with Supabase

19
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

34
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
Optimizing Active Record queries

Optimizing Active Record queries

43
Comments 1
11 min read
A List of PostgreSQL Commands for Beginners

A List of PostgreSQL Commands for Beginners

5
Comments
4 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?

16
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
loading...