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.
In 48 hours, I’ve created License Key APIs using Supabase.

In 48 hours, I’ve created License Key APIs using Supabase.

Reactions 6 Comments
2 min read
Connect your Java application with any SQL databases

Connect your Java application with any SQL databases

Reactions 10 Comments
4 min read
Entity Framework Core Add if not exist

Entity Framework Core Add if not exist

Reactions 5 Comments
1 min read
How to use SQL Server T-SQL function CHARINDEX in SQL queries

How to use SQL Server T-SQL function CHARINDEX in SQL queries

Reactions 6 Comments
6 min read
pg_stat_statements in YugabyteDB

pg_stat_statements in YugabyteDB

Reactions 4 Comments
2 min read
Is software immortal? And can we hide columns in Postgres?

Is software immortal? And can we hide columns in Postgres?

Reactions 3 Comments
5 min read
PostgreSQL: An example of using WITH clauses to decompose the problem

PostgreSQL: An example of using WITH clauses to decompose the problem

Reactions 5 Comments
2 min read
SQL Interview Questions CheatSheet

SQL Interview Questions CheatSheet

Reactions 7 Comments 2
7 min read
SQL-Quick tip #13 - Index usage

SQL-Quick tip #13 - Index usage

Reactions 5 Comments
1 min read
Amazon Aurora's Read/Write Capability Enhancement with Apache ShardingSphere-Proxy

Amazon Aurora's Read/Write Capability Enhancement with Apache ShardingSphere-Proxy

Reactions 6 Comments
26 min read
SQL Schema in Django Models

SQL Schema in Django Models

Reactions 8 Comments
1 min read
SQL-Quick tip #14 - Server information

SQL-Quick tip #14 - Server information

Reactions 9 Comments
1 min read
Your Guide to DistSQL Cluster Governance Capability——Apache ShardingSphere Feature Update

Your Guide to DistSQL Cluster Governance Capability——Apache ShardingSphere Feature Update

Reactions 9 Comments
9 min read
Announcing Atlas Project Files

Announcing Atlas Project Files

Reactions 9 Comments
3 min read
5 tips to optimize your CQL queries

5 tips to optimize your CQL queries

Reactions 11 Comments
5 min read
Query compressed logs that are stored in S3 using AWS Athena

Query compressed logs that are stored in S3 using AWS Athena

Reactions 9 Comments
5 min read
"I want to try it" 🚀 YugabyteDB at KubeCon

"I want to try it" 🚀 YugabyteDB at KubeCon

Reactions 10 Comments
2 min read
Postgres: Setup & Basics

Postgres: Setup & Basics

Reactions 5 Comments 2
3 min read
How to create a View in SQL Server

How to create a View in SQL Server

Reactions 9 Comments
9 min read
How does Apache ShardingSphere implement distributed transactions?

How does Apache ShardingSphere implement distributed transactions?

Reactions 6 Comments
8 min read
Xamarin Android: Create Login Using SQLite Database | iFour Technolab

Xamarin Android: Create Login Using SQLite Database | iFour Technolab

Reactions 6 Comments
5 min read
Recover your Dropped Table from the Recyclebin ⛅�?�

Recover your Dropped Table from the Recyclebin ⛅�?�

Reactions 3 Comments
1 min read
Workout Programmer

Workout Programmer

Reactions 10 Comments
6 min read
How To Prevent SQL Injection In PHP: Three Essential Methods

How To Prevent SQL Injection In PHP: Three Essential Methods

Reactions 10 Comments
4 min read
Top 10 SQL Queries asked in Interviews

Top 10 SQL Queries asked in Interviews

Reactions 9 Comments 1
3 min read
SQL-Quick tip #12 - Available disk space

SQL-Quick tip #12 - Available disk space

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

Think twice before using AGE in PotgreSQL

Reactions 8 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

Reactions 3 Comments
1 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

Reactions 7 Comments 1
4 min read
Database Migration: SQLite to PostgreSQL

Database Migration: SQLite to PostgreSQL

Reactions 3 Comments
5 min read
�??OID <-> 🚀table_id

�??OID <-> 🚀table_id

Reactions 7 Comments
4 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

Reactions 6 Comments
5 min read
Databases in Python Made Easy with SQLAlchemy

Databases in Python Made Easy with SQLAlchemy

Reactions 2 Comments
10 min read
SQL vs. NoSQL

SQL vs. NoSQL

Reactions 16 Comments 9
2 min read
SQLite - Acessando seu banco diretamente do VSCode

SQLite - Acessando seu banco diretamente do VSCode

Reactions 5 Comments
3 min read
My Brush with Analytics Engineering

My Brush with Analytics Engineering

Reactions 6 Comments
5 min read
SQL-Quick tip #11 - Most intensive queries

SQL-Quick tip #11 - Most intensive queries

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

Amazon RDS Proxy makes it easier to use SQL in Serverless

Reactions 5 Comments
4 min read
Reusable SQL templates: learn about SQL Macros🤯

Reusable SQL templates: learn about SQL Macros🤯

Reactions 6 Comments
2 min read
SQL-Quick tip #8 - Finding foreign key constraints

SQL-Quick tip #8 - Finding foreign key constraints

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

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

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

5 Best Public Datasets to Practice Your Data Analysis Skills

Reactions 6 Comments
6 min read
Magical Bulk Insertion in Rails 6

Magical Bulk Insertion in Rails 6

Reactions 3 Comments 3
1 min read
🚀 YugabyteDB on fly.io - I - yugabyted

🚀 YugabyteDB on fly.io - I - yugabyted

Reactions 10 Comments
8 min read
Smart list of values in SQL with LISTAGG

Smart list of values in SQL with LISTAGG

Reactions 4 Comments
1 min read
SQL-Quick tip #7 - Find stored procedures

SQL-Quick tip #7 - Find stored procedures

Reactions 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

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

SQL-Quick tip #10 - Select table definition

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

Optimizing database query - In a loop

Reactions 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

Reactions 9 Comments
3 min read
When Disaster Strikes: Production Troubleshooting

When Disaster Strikes: Production Troubleshooting

Reactions 10 Comments 1
6 min read
MySQL Cheatsheet

MySQL Cheatsheet

Reactions 9 Comments
8 min read
Instantly query AWS with SQL in CloudShell

Instantly query AWS with SQL in CloudShell

Reactions 15 Comments
3 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)

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

How to add SQL editor to your django admin.

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

How To Choose An Efficient Storage For Data.

Reactions 4 Comments
2 min read
SQL Basic Cheat Sheet

SQL Basic Cheat Sheet

Reactions 32 Comments
3 min read
[ Database ] - SQLAlchemy "or_" function

[ Database ] - SQLAlchemy "or_" function

Reactions 7 Comments
1 min read
Optimiza tu aplicación rails utilizando índices en Postgres

Optimiza tu aplicación rails utilizando índices en Postgres

Reactions 19 Comments
13 min read
Insert CSV Rows into a Database Using Vanilla Ruby

Insert CSV Rows into a Database Using Vanilla Ruby

Reactions 6 Comments
6 min read
loading...