Skip to content
Search Create account

DEV Community

DEV Community is a community of 853,631 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.
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
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
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
pg_stat_statements in YugabyteDB
franckpachot profile

pg_stat_statements in YugabyteDB

#yugabytedb #postgres #monitoring #sql
Reactions 4 Comments
2 min read
Is software immortal? And can we hide columns in Postgres?
enteio profile
ente

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

#sql #postgres #tutorial #programming
Reactions 3 Comments
5 min read
PostgreSQL: An example of using WITH clauses to decompose the problem
franckpachot profile

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

#yugabytedb #postgres #sql #cte
Reactions 5 Comments
2 min read
SQL Interview Questions CheatSheet
zainshahbaz786 profile

SQL Interview Questions CheatSheet

#database #sql #programming #mysql
Reactions 7 Comments 2
7 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
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 6 Comments
26 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
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
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 10 Comments
4 min read
Top 10 SQL Queries asked in Interviews
rahul_14 profile

Top 10 SQL Queries asked in Interviews

#beginners #sql #query #interview
Reactions 9 Comments 1
3 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