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 Aurora's Read/Write Capability Enhancement with Apache ShardingSphere-Proxy

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

Reactions 4 Comments
26 min read
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
SQL Interview Questions CheatSheet

SQL Interview Questions CheatSheet

Reactions 6 Comments 2
7 min read
Entity Framework Core Add if not exist

Entity Framework Core Add if not exist

Reactions 5 Comments
1 min read
Top 10 SQL Queries asked in Interviews

Top 10 SQL Queries asked in Interviews

Reactions 8 Comments 1
3 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
SQL-Quick tip #13 - Index usage

SQL-Quick tip #13 - Index usage

Reactions 5 Comments
1 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
How To Prevent SQL Injection In PHP: Three Essential Methods

How To Prevent SQL Injection In PHP: Three Essential Methods

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