The Wayback Machine - https://web.archive.org/web/20211006123847/https://dev.to/t/sql

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
SQL Server to React in 60 Seconds With Prisma

SQL Server to React in 60 Seconds With Prisma

Reactions 12 Comments
5 min read
What's New in PostgreSQL 14?

What's New in PostgreSQL 14?

Reactions 2 Comments
5 min read
Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

Reactions 8 Comments
1 min read
Code in Public - Time Management website

Code in Public - Time Management website

Reactions 2 Comments
1 min read
SQL Constraints

SQL Constraints

Reactions 3 Comments
4 min read
How To Fix Slow MariaDB Replication Lag

How To Fix Slow MariaDB Replication Lag

Reactions 5 Comments
2 min read
First NoSQL For SQL Developers

First NoSQL For SQL Developers

Reactions 3 Comments 1
2 min read
A Data Spider in Recursive SQL

A Data Spider in Recursive SQL

Reactions 2 Comments
11 min read
[TIL] Mysql Stuff

[TIL] Mysql Stuff

Reactions 1 Comments
1 min read
Replacing Segment Computed & SQL Traits With dbt & RudderStack Warehouse Actions

Replacing Segment Computed & SQL Traits With dbt & RudderStack Warehouse Actions

Reactions 5 Comments
11 min read
How to do a Select clause comparison of LocalDateTime in JPA

How to do a Select clause comparison of LocalDateTime in JPA

Reactions 2 Comments
1 min read
Introduction to the Join Ordering Problem

Introduction to the Join Ordering Problem

Reactions 5 Comments
4 min read
Find Out What It Means to be a Data Scientist at Microsoft

Find Out What It Means to be a Data Scientist at Microsoft

Reactions 3 Comments
14 min read
Schemaless SQL database for strong and lasting back end

Schemaless SQL database for strong and lasting back end

Reactions 8 Comments
2 min read
🚀 The Missing SQL Basics Crash Course

🚀 The Missing SQL Basics Crash Course

Reactions 100 Comments 8
12 min read
Hindsight 20/20: Querying Any Point in Time

Hindsight 20/20: Querying Any Point in Time

Reactions 5 Comments
2 min read
MongoDB equivalent of SQL LIKE query

MongoDB equivalent of SQL LIKE query

Reactions 5 Comments
1 min read
FAQ: blockchain technology in bSQL

FAQ: blockchain technology in bSQL

Reactions 2 Comments
2 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

Reactions 157 Comments 25
5 min read
Performant script in updating a large table🚀

Performant script in updating a large table🚀

Reactions 12 Comments
3 min read
SQL Lock to give you shock

SQL Lock to give you shock

Reactions 3 Comments
2 min read
Four Database APIs

Four Database APIs

Reactions 7 Comments
15 min read
Making SQLite Easy with Codesphere!

Making SQLite Easy with Codesphere!

Reactions 11 Comments
2 min read
when you have millions of insert statements in a file...

when you have millions of insert statements in a file...

Reactions 25 Comments
6 min read
SQL SERVER REMOTE CONFIGURATIONS ON LINUX

SQL SERVER REMOTE CONFIGURATIONS ON LINUX

Reactions 2 Comments
2 min read
Windows Server Üzerinde SQLite Kullanımı

Windows Server Üzerinde SQLite Kullanımı

Reactions 3 Comments
3 min read
SQL Injection Attacks and How Developers Can Prevent Them

SQL Injection Attacks and How Developers Can Prevent Them

Reactions 32 Comments 2
7 min read
In the mist of the Big Data Hype, Let’s Discuss MySQL

In the mist of the Big Data Hype, Let’s Discuss MySQL

Reactions 4 Comments
4 min read
Infrastructure as SQL

Infrastructure as SQL

Reactions 33 Comments 4
3 min read
Yammer: My personal dive into a practice business problem

Yammer: My personal dive into a practice business problem

Reactions 3 Comments
10 min read
Simple Scalable Search Autocomplete Systems

Simple Scalable Search Autocomplete Systems

Reactions 6 Comments 1
6 min read
mysql 101

mysql 101

Reactions 3 Comments
5 min read
SQL Query into Pandas DataFrame - Part 3

SQL Query into Pandas DataFrame - Part 3

Reactions 5 Comments
1 min read
I'm building a modern spreadsheet

I'm building a modern spreadsheet

Reactions 5 Comments
9 min read
sql vs. nosql

sql vs. nosql

Reactions 2 Comments
1 min read
What is SQL and What Its Value?

What is SQL and What Its Value?

Reactions 2 Comments
2 min read
Databases: Important Theoretical Concepts

Databases: Important Theoretical Concepts

Reactions 15 Comments
4 min read
Windows Server Üzerinde SQLite Kurulumu

Windows Server Üzerinde SQLite Kurulumu

Reactions 6 Comments
2 min read
Another SQL cheat sheet

Another SQL cheat sheet

Reactions 17 Comments
5 min read
10 Ways to optimise your Database queries

10 Ways to optimise your Database queries

Reactions 24 Comments 2
7 min read
Decentralized Security From a Centralized Database

Decentralized Security From a Centralized Database

Reactions 5 Comments
4 min read
SQL : JSON Datatype

SQL : JSON Datatype

Reactions 6 Comments
4 min read
SQL : Internal Functions

SQL : Internal Functions

Reactions 3 Comments
4 min read
SQL : Date/ Time and TimeStamps

SQL : Date/ Time and TimeStamps

Reactions 2 Comments
3 min read
SQL : Arrays

SQL : Arrays

Reactions 2 Comments
5 min read
SQL : Sequences

SQL : Sequences

Reactions 2 Comments
1 min read
SQL : User Defined Datatypes

SQL : User Defined Datatypes

Reactions 2 Comments
3 min read
SQL : DataTypes

SQL : DataTypes

Reactions 2 Comments
6 min read
SQL Query into Pandas DataFrame - Part 2

SQL Query into Pandas DataFrame - Part 2

Reactions 2 Comments
1 min read
Migration from Mssqlserver to Mongodb for Developers

Migration from Mssqlserver to Mongodb for Developers

Reactions 3 Comments
12 min read
Announcing Hightouch Audiences: Enabling Marketers to Self-Serve their Data

Announcing Hightouch Audiences: Enabling Marketers to Self-Serve their Data

Reactions 1 Comments
5 min read
Deleting duplicate value at the same column in table of sql

Deleting duplicate value at the same column in table of sql

Reactions 8 Comments 1
1 min read
SQL Injection 101

SQL Injection 101

Reactions 10 Comments 2
5 min read
UUID or cached sequences?

UUID or cached sequences?

Reactions 9 Comments
7 min read
SQL Basics: INNER JOINs vs LEFT JOINs

SQL Basics: INNER JOINs vs LEFT JOINs

Reactions 4 Comments
3 min read
Beware the Performance Dangers of MySQL Views

Beware the Performance Dangers of MySQL Views

Reactions 24 Comments 1
3 min read
SQL 101: How to Insert and Update Data From Databases Using SQL

SQL 101: How to Insert and Update Data From Databases Using SQL

Reactions 2 Comments
4 min read
Redshift es compatible con vistas materializadas!

Redshift es compatible con vistas materializadas!

Reactions 2 Comments
2 min read
CockroachDB Grants and Schemas explained

CockroachDB Grants and Schemas explained

Reactions 5 Comments
10 min read
SQL Performance - pagination scalability

SQL Performance - pagination scalability

Reactions 3 Comments
1 min read
loading...