Skip to content
Search Create account

DEV Community

DEV Community is a community of 865,568 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
Twitter Facebook Github Instagram Twitch

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
apache_shardingsphere profile

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

#database #aws #opensource #sql
Reactions 4 Comments
26 min read
In 48 hours, I’ve created License Key APIs using Supabase.
pradeepb28_ profile

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

#api #backend #postgres #sql
Reactions 6 Comments
2 min read
Connect your Java application with any SQL databases
3imed_jaberi profile

Connect your Java application with any SQL databases

#java #mysql #sql #jdbc
Reactions 10 Comments
4 min read
SQL Interview Questions CheatSheet
zainshahbaz786 profile

SQL Interview Questions CheatSheet

#database #sql #programming #mysql
Reactions 6 Comments 2
7 min read
Entity Framework Core Add if not exist
alexgreatdev profile
Alex

Entity Framework Core Add if not exist

#netcore #efcore #sql #dotnet
Reactions 5 Comments
1 min read
Top 10 SQL Queries asked in Interviews
rahul_14 profile

Top 10 SQL Queries asked in Interviews

#beginners #sql #query #interview
Reactions 8 Comments 1
3 min read
How to use SQL Server T-SQL function CHARINDEX in SQL queries
manvendradeosingh profile

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

#beginners #sql #database
Reactions 6 Comments
6 min read
SQL-Quick tip #13 - Index usage
coderallan profile

SQL-Quick tip #13 - Index usage

#tsql #sqlserver #sql #mssql
Reactions 5 Comments
1 min read
SQL Schema in Django Models
koladev profile

SQL Schema in Django Models

#django #database #python #sql
Reactions 8 Comments
1 min read
SQL-Quick tip #14 - Server information
coderallan profile

SQL-Quick tip #14 - Server information

#tsql #sqlserver #sql #mssql
Reactions 9 Comments
1 min read
Your Guide to DistSQL Cluster Governance Capability——Apache ShardingSphere Feature Update
apache_shardingsphere profile

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

#sql #database #opensource #tutorial
Reactions 9 Comments
9 min read
Announcing Atlas Project Files
rotemtam profile

Announcing Atlas Project Files

#database #migrations #sql #devops
Reactions 9 Comments
3 min read
How To Prevent SQL Injection In PHP: Three Essential Methods
emmykolic profile

How To Prevent SQL Injection In PHP: Three Essential Methods

#php #sql #tutorial
Reactions 8 Comments
4 min read
5 tips to optimize your CQL queries
raoufchebri profile

5 tips to optimize your CQL queries

#database #productivity #sql
Reactions 11 Comments
5 min read
Query compressed logs that are stored in S3 using AWS Athena
willianantunes profile

Query compressed logs that are stored in S3 using AWS Athena

#aws #s3 #serverless #sql
Reactions 9 Comments
5 min read
"I want to try it" 🚀 YugabyteDB at KubeCon
franckpachot profile

"I want to try it" 🚀 YugabyteDB at KubeCon

#kubecon #distributed #sql #yugabytedb
Reactions 10 Comments
2 min read
Postgres: Setup & Basics
seantansey profile

Postgres: Setup & Basics

#postgres #webdev #tutorial #sql
Reactions 5 Comments 2
3 min read
How to create a View in SQL Server
manvendradeosingh profile

How to create a View in SQL Server

#beginners #database #sql
Reactions 9 Comments
9 min read
How does Apache ShardingSphere implement distributed transactions?
apache_shardingsphere profile

How does Apache ShardingSphere implement distributed transactions?

#apache #database #opensource #sql
Reactions 6 Comments
8 min read
Xamarin Android: Create Login Using SQLite Database | iFour Technolab
harshalsuthar profile

Xamarin Android: Create Login Using SQLite Database | iFour Technolab

#xamarin #xamarinforms #sql #database
Reactions 6 Comments
5 min read
Recover your Dropped Table from the Recyclebin ⛅😎
loiclefevre profile

Recover your Dropped Table from the Recyclebin ⛅😎

#database #sql #productivity
Reactions 3 Comments
1 min read
Workout Programmer
michaellobman profile

Workout Programmer

#ruby #rails #react #sql
Reactions 10 Comments
6 min read
SQL-Quick tip #12 - Available disk space
coderallan profile

SQL-Quick tip #12 - Available disk space

#tsql #sqlserver #sql #mssql
Reactions 7 Comments
2 min read
Think twice before using AGE in PotgreSQL
bajena profile

Think twice before using AGE in PotgreSQL

#sql #time
Reactions 8 Comments
2 min read
Multi-level Aggregation Using MySQL GROUP BY WITH ROLLUP - OpenLampTech Repost
j2112o profile

Multi-level Aggregation Using MySQL GROUP BY WITH ROLLUP - OpenLampTech Repost

#mysql #database #programming #sql
Reactions 3 Comments
1 min read
SQL: One to Many Join Query in an Optimal way with Node.js
ali_a_koye profile

SQL: One to Many Join Query in an Optimal way with Node.js

#sql #node #javascript #tutorial
Reactions 7 Comments 1
4 min read
Database Migration: SQLite to PostgreSQL
lucylu8l profile

Database Migration: SQLite to PostgreSQL

#database #postgres #sql
Reactions 3 Comments
5 min read
🐘OID <-> 🚀table_id
franckpachot profile

🐘OID <-> 🚀table_id

#yugabytedb #distributed #sql #database
Reactions 7 Comments
4 min read
SQL Triggers with AWS Lambda — Take Your DB to the Next Level
liavyona profile

SQL Triggers with AWS Lambda — Take Your DB to the Next Level

#sql #aws #serverless #database
Reactions 6 Comments
5 min read
Databases in Python Made Easy with SQLAlchemy
toddbirchard profile

Databases in Python Made Easy with SQLAlchemy

#sqlalchemy #sql #python #data
Reactions 2 Comments
10 min read
SQL vs. NoSQL
patik123 profile

SQL vs. NoSQL

#database #sql #beginners #webdev
Reactions 16 Comments 8
2 min read
SQLite - Acessando seu banco diretamente do VSCode
jhonywalkeer profile

SQLite - Acessando seu banco diretamente do VSCode

#beginners #programming #vscode #sql
Reactions 5 Comments
3 min read
My Brush with Analytics Engineering
butchland profile

My Brush with Analytics Engineering

#dbt #vscode #analytics #sql
Reactions 6 Comments
5 min read
SQL-Quick tip #11 - Most intensive queries
coderallan profile

SQL-Quick tip #11 - Most intensive queries

#tsql #sqlserver #sql #mssql
Reactions 10 Comments
2 min read
Amazon RDS Proxy makes it easier to use SQL in Serverless
goserverless profile

Amazon RDS Proxy makes it easier to use SQL in Serverless

#aws #rdsproxy #sql #serverless
Reactions 5 Comments
4 min read
Reusable SQL templates: learn about SQL Macros🤯
loiclefevre profile

Reusable SQL templates: learn about SQL Macros🤯

#database #sql #programming #productivity
Reactions 6 Comments
2 min read
SQL-Quick tip #8 - Finding foreign key constraints
coderallan profile

SQL-Quick tip #8 - Finding foreign key constraints

#tsql #sqlserver #sql #mssql
Reactions 6 Comments
1 min read
SQL Basic - What you need to know! (Basics)
ochwada profile

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

#sql #beginners #programming #womenintech
Reactions 6 Comments
2 min read
5 Best Public Datasets to Practice Your Data Analysis Skills
rettx profile

5 Best Public Datasets to Practice Your Data Analysis Skills

#sql #programming #productivity #database
Reactions 6 Comments
6 min read
Magical Bulk Insertion in Rails 6
moiz1524 profile

Magical Bulk Insertion in Rails 6

#ruby #rails #development #sql
Reactions 3 Comments 3
1 min read
🚀 YugabyteDB on fly.io - I - yugabyted
franckpachot profile

🚀 YugabyteDB on fly.io - I - yugabyted

#yugabytedb #distributed #sql #database
Reactions 10 Comments
8 min read
Smart list of values in SQL with LISTAGG
loiclefevre profile
Loïc

Smart list of values in SQL with LISTAGG

#database #sql #programming
Reactions 4 Comments
1 min read