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.
SQL-Quick tip #5 - Create a sequence of date and time

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

19
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
SQL-Quick tip #3 - Prepending zeroes

SQL-Quick tip #3 - Prepending zeroes

6
Comments
1 min read
Criação de um Micro ORM

Criação de um Micro ORM

2
Comments
2 min read
Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

7
Comments
10 min read
A way to translate sql scripts to a different dialect

A way to translate sql scripts to a different dialect

2
Comments
1 min read
Introduction to SQL

Introduction to SQL

3
Comments
2 min read
Query S3 with SQL using S3 Select

Query S3 with SQL using S3 Select

11
Comments
5 min read
How to generate time-series data in QuestDB

How to generate time-series data in QuestDB

9
Comments 1
9 min read
Combining dbt Metrics with API, Caching, and Access Control

Combining dbt Metrics with API, Caching, and Access Control

17
Comments
9 min read
10 AWS Services that use SQL

10 AWS Services that use SQL

6
Comments
11 min read
SQL undercover

SQL undercover

2
Comments
2 min read
Logical Grouping in Laravel Query Builder

Logical Grouping in Laravel Query Builder

6
Comments
2 min read
Postgres variables & clean up

Postgres variables & clean up

3
Comments
1 min read
16 Data Analytics Buzzwords You Need To Know

16 Data Analytics Buzzwords You Need To Know

19
Comments
2 min read
SQL-Quick tip #4 - Random Int for each row

SQL-Quick tip #4 - Random Int for each row

14
Comments
1 min read
Saving the UNION with HoneySQL

Saving the UNION with HoneySQL

7
Comments 1
5 min read
Ensuring Conversion of a Float to Nvarchar in T-SQL

Ensuring Conversion of a Float to Nvarchar in T-SQL

5
Comments
2 min read
PHP e SQL Benchmark: Múltiplos joins VS várias queries menores

PHP e SQL Benchmark: Múltiplos joins VS várias queries menores

6
Comments
5 min read
Handling Dynamic Objects in CrateDB

Handling Dynamic Objects in CrateDB

3
Comments
7 min read
Avoiding hotspots in pgbench on PostgreSQL or YugabyteDB

Avoiding hotspots in pgbench on PostgreSQL or YugabyteDB

5
Comments
10 min read
Ultimate Guide to Learn SQL Basics Intermediate Advanced

Ultimate Guide to Learn SQL Basics Intermediate Advanced

18
Comments
4 min read
Self-Service Machine Learning with Intelligent Databases

Self-Service Machine Learning with Intelligent Databases

8
Comments
10 min read
Creating a Node.js SQL Library

Creating a Node.js SQL Library

30
Comments 2
4 min read
Querying GitHub data with SQL: Insights for developers and engineering leaders

Querying GitHub data with SQL: Insights for developers and engineering leaders

5
Comments
5 min read
🛡Vulnerabilidad en login con PHP💉Ataque SQL INJECTION

🛡Vulnerabilidad en login con PHP💉Ataque SQL INJECTION

12
Comments
2 min read
Introdução a Modelagem de Banco de Dados - SQL

Introdução a Modelagem de Banco de Dados - SQL

18
Comments
5 min read
Top 13 data engineer interview questions (and tips)

Top 13 data engineer interview questions (and tips)

6
Comments
9 min read
Intro to Postgres enums

Intro to Postgres enums

8
Comments
3 min read
SQL Commands with C#

SQL Commands with C#

14
Comments 2
2 min read
How to export and import data in DBeaver

How to export and import data in DBeaver

83
Comments 2
1 min read
Introdução aos JOINs - SQL

Introdução aos JOINs - SQL

8
Comments
3 min read
Amazon RDS

Amazon RDS

Comments
3 min read
Funções mais Usadas no SQL

Funções mais Usadas no SQL

9
Comments
5 min read
Ruby on Rails: Switch From sqlite3 to Postgres using asdf

Ruby on Rails: Switch From sqlite3 to Postgres using asdf

6
Comments
2 min read
Understand SQL cartisien product !

Understand SQL cartisien product !

3
Comments
1 min read
How to use pg_cron in postgres to do historic aggregation?

How to use pg_cron in postgres to do historic aggregation?

7
Comments
2 min read
Normalização do Tipo de Identificação

Normalização do Tipo de Identificação

5
Comments
2 min read
Atributos e Tabelas para Estados

Atributos e Tabelas para Estados

3
Comments
2 min read
Simplificar queries com Views SQL

Simplificar queries com Views SQL

3
Comments
2 min read
Limitar a Inserção de Registos

Limitar a Inserção de Registos

3
Comments
1 min read
YugabyteDB on Public network 🚀🌐

YugabyteDB on Public network 🚀🌐

4
Comments
7 min read
Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

5
Comments
4 min read
The ultimate solution to image storage.

The ultimate solution to image storage.

5
Comments 2
1 min read
How to build a Trading bot with Python and SQlite.

How to build a Trading bot with Python and SQlite.

14
Comments
5 min read
Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

9
Comments 2
7 min read
SQL-Quick tip #1 - Range of Int

SQL-Quick tip #1 - Range of Int

7
Comments
1 min read
Drop all tables and reset an Azure SQL Database

Drop all tables and reset an Azure SQL Database

10
Comments
1 min read
What is the difference between DATETIME and TIMESTAMP data type in MySQL?

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

21
Comments 2
3 min read
How do I extract a nested tuple from a tuple?

How do I extract a nested tuple from a tuple?

2
Comments 1
1 min read
Introdução a Manipulação de Dados - SQL

Introdução a Manipulação de Dados - SQL

6
Comments
4 min read
Reference Tables as duplicate covering indexes

Reference Tables as duplicate covering indexes

7
Comments
16 min read
Introdução a Filtragem de Dados - SQL

Introdução a Filtragem de Dados - SQL

8
Comments
4 min read
Get rid of an MS SQL Server database in SingleUserMode

Get rid of an MS SQL Server database in SingleUserMode

6
Comments
1 min read
Introdução a Pesquisa de Dados - SQL

Introdução a Pesquisa de Dados - SQL

8
Comments
5 min read
Introdução ao SQL

Introdução ao SQL

11
Comments 6
4 min read
How to provision an Azure SQL Database with Active Directory authentication

How to provision an Azure SQL Database with Active Directory authentication

11
Comments
13 min read
loading...