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.
Removendo registros duplicados de uma tabela no PostgreSQL

Removendo registros duplicados de uma tabela no PostgreSQL

1
Comments
2 min read
To SQL or NoSQL?

To SQL or NoSQL?

9
Comments
5 min read
How to create function in MySQL

How to create function in MySQL

3
Comments
1 min read
How to use delimiter in MySQL

How to use delimiter in MySQL

2
Comments
1 min read
How to import json to SQL

How to import json to SQL

Comments
1 min read
Build a SQL GUI in 5 Steps with Budibase

Build a SQL GUI in 5 Steps with Budibase

3
Comments
14 min read
Ideal Transformation Steps in dbt

Ideal Transformation Steps in dbt

2
Comments
3 min read
Effective Queries with Rails and PostgreSQL

Effective Queries with Rails and PostgreSQL

15
Comments
14 min read
MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

2
Comments
8 min read
4 Step Strategy to Migrate SQL Server to Azure Cloud

4 Step Strategy to Migrate SQL Server to Azure Cloud

2
Comments
1 min read
Stop writing your SQL code inside your Go source files!

Stop writing your SQL code inside your Go source files!

41
Comments 6
2 min read
SQLAlchemy Expression Language - Just Enough

SQLAlchemy Expression Language - Just Enough

4
Comments 2
8 min read
Quick tip: Using SQLAlchemy with SingleStoreDB

Quick tip: Using SQLAlchemy with SingleStoreDB

2
Comments
5 min read
Command-line data analytics made easy with SPyQL

Command-line data analytics made easy with SPyQL

6
Comments
6 min read
🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

Comments
5 min read
PostgreSQL unit-11

PostgreSQL unit-11

Comments
1 min read
My Hacktober 2022 Contributions mostly SQL DDL uml extensions

My Hacktober 2022 Contributions mostly SQL DDL uml extensions

1
Comments
2 min read
YugabyteDB cloud/region/zone

YugabyteDB cloud/region/zone

3
Comments
4 min read
How to set Read Committed in YugabyteDB

How to set Read Committed in YugabyteDB

3
Comments 2
2 min read
DDL on SQLAlchemy Core API

DDL on SQLAlchemy Core API

5
Comments
4 min read
Geo Location Search with SQL Server

Geo Location Search with SQL Server

3
Comments 1
2 min read
plsql anonymous blocks

plsql anonymous blocks

2
Comments
1 min read
Hibernate One to Many Example using Annotation

Hibernate One to Many Example using Annotation

3
Comments
3 min read
Transitioning from NoSQL to also implementing SQL

Transitioning from NoSQL to also implementing SQL

3
Comments
1 min read
Creating an API using Go and sqlc

Creating an API using Go and sqlc

12
Comments 2
11 min read
Product Scalability In Startups And How To Choose A Database As A Lead Engineer.

Product Scalability In Startups And How To Choose A Database As A Lead Engineer.

22
Comments
10 min read
How to build an Application with PHP and PostgreSQL

How to build an Application with PHP and PostgreSQL

7
Comments 3
4 min read
SQL + Python + Spark for Data Science

SQL + Python + Spark for Data Science

6
Comments
38 min read
We launched an open source ClickHouse Knowledge Base

We launched an open source ClickHouse Knowledge Base

2
Comments
2 min read
Postgres Views in Supabase Have Only One Problem

Postgres Views in Supabase Have Only One Problem

2
Comments 2
3 min read
SQL 101

SQL 101

3
Comments
1 min read
PostgreSQL unit-10

PostgreSQL unit-10

Comments
1 min read
Dolt - SQL database for Git

Dolt - SQL database for Git

5
Comments 4
1 min read
PostgreSQL unit-9

PostgreSQL unit-9

Comments
1 min read
Laravel Query nested JSON Column without case sensitivity

Laravel Query nested JSON Column without case sensitivity

3
Comments 1
1 min read
PostgreSQL unit-7

PostgreSQL unit-7

Comments
1 min read
PostgreSQL unit-8

PostgreSQL unit-8

Comments
1 min read
PostgresSQL unit-6

PostgresSQL unit-6

Comments
1 min read
Event triggers on MS SQL Server database

Event triggers on MS SQL Server database

3
Comments
4 min read
YugabyteDB Skip Scan aka Loose Index Scan on compound index

YugabyteDB Skip Scan aka Loose Index Scan on compound index

2
Comments
5 min read
Database Interaction with SQLAlchemy - Raw DML & DQL

Database Interaction with SQLAlchemy - Raw DML & DQL

4
Comments
6 min read
SQL vs NoSQL: Choosing a database for your next project

SQL vs NoSQL: Choosing a database for your next project

48
Comments 2
11 min read
How to re-sync auto-increment in PostgreSQL

How to re-sync auto-increment in PostgreSQL

7
Comments
1 min read
Exact match search deeply nested objects - PostgreSQL

Exact match search deeply nested objects - PostgreSQL

2
Comments
2 min read
Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

5
Comments
6 min read
Predict Store Sales Data With MindsDB using Machine Learning and SQL

Predict Store Sales Data With MindsDB using Machine Learning and SQL

2
Comments
3 min read
Database Interaction with SQLAlchemy - Raw DDL Tour

Database Interaction with SQLAlchemy - Raw DDL Tour

2
Comments
7 min read
Importing 3m rows/sec with io_uring

Importing 3m rows/sec with io_uring

Comments
11 min read
How does ShardingSphere’s Show processlist & Kill Work?

How does ShardingSphere’s Show processlist & Kill Work?

Comments
9 min read
Kaplan Meier Estimator in Python

Kaplan Meier Estimator in Python

3
Comments
5 min read
Laravel: Alter a foreign key constraint

Laravel: Alter a foreign key constraint

1
Comments
2 min read
Indexes in SQL {Using Rails}

Indexes in SQL {Using Rails}

2
Comments
2 min read
An Introduction To Databases

An Introduction To Databases

Comments
5 min read
SingleStore - is there a workaround for unsupported Foreign Key?

SingleStore - is there a workaround for unsupported Foreign Key?

2
Comments
6 min read
AWS Provider for StackQL Released

AWS Provider for StackQL Released

Comments
1 min read
Uso de sp_helptext nameprocedure en SQLSERVER

Uso de sp_helptext nameprocedure en SQLSERVER

Comments
1 min read
Alterar tabla de base de datos y agregar llaves foraneas.

Alterar tabla de base de datos y agregar llaves foraneas.

2
Comments
1 min read
PostgresSQL unit-2

PostgresSQL unit-2

1
Comments
1 min read
PostgresSQL unit-1

PostgresSQL unit-1

Comments
1 min read
SQL Server Recovery Model

SQL Server Recovery Model

1
Comments
2 min read
loading...