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

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

What's New in PostgreSQL 14?

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

Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

8
1 min read
Code in Public - Time Management website

Code in Public - Time Management website

2
1 min read
SQL Constraints

SQL Constraints

3
4 min read
How To Fix Slow MariaDB Replication Lag

How To Fix Slow MariaDB Replication Lag

5
2 min read
First NoSQL For SQL Developers

First NoSQL For SQL Developers

3 1
2 min read
A Data Spider in Recursive SQL

A Data Spider in Recursive SQL

2
11 min read
[TIL] Mysql Stuff

[TIL] Mysql Stuff

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

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

5
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

2
1 min read
Introduction to the Join Ordering Problem

Introduction to the Join Ordering Problem

5
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

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

Schemaless SQL database for strong and lasting back end

8
2 min read
πŸš€ The Missing SQL Basics Crash Course

πŸš€ The Missing SQL Basics Crash Course

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

Hindsight 20/20: Querying Any Point in Time

5
2 min read
MongoDB equivalent of SQL LIKE query

MongoDB equivalent of SQL LIKE query

5
1 min read
FAQ: blockchain technology in bSQL

FAQ: blockchain technology in bSQL

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

Should I use SQLite, PostgreSQL, or MySQL?

157 25
5 min read
Performant script in updating a large tableπŸš€

Performant script in updating a large tableπŸš€

12
3 min read
SQL Lock to give you shock

SQL Lock to give you shock

3
2 min read
Four Database APIs

Four Database APIs

7
15 min read
Making SQLite Easy with Codesphere!

Making SQLite Easy with Codesphere!

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

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

25
6 min read
SQL SERVER REMOTE CONFIGURATIONS ON LINUX

SQL SERVER REMOTE CONFIGURATIONS ON LINUX

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

Windows Server Üzerinde SQLite Kullanımı

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

SQL Injection Attacks and How Developers Can Prevent Them

32 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

4
4 min read
Infrastructure as SQL

Infrastructure as SQL

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

Yammer: My personal dive into a practice business problem

3
10 min read
Simple Scalable Search Autocomplete Systems

Simple Scalable Search Autocomplete Systems

6 1
6 min read
mysql 101

mysql 101

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

SQL Query into Pandas DataFrame - Part 3

5
1 min read
I'm building a modern spreadsheet

I'm building a modern spreadsheet

5
9 min read
sql vs. nosql

sql vs. nosql

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

What is SQL and What Its Value?

2
2 min read
Databases: Important Theoretical Concepts

Databases: Important Theoretical Concepts

15
4 min read
Windows Server Üzerinde SQLite Kurulumu

Windows Server Üzerinde SQLite Kurulumu

6
2 min read
Another SQL cheat sheet

Another SQL cheat sheet

17
5 min read
10 Ways to optimise your Database queries

10 Ways to optimise your Database queries

24 2
7 min read
Decentralized Security From a Centralized Database

Decentralized Security From a Centralized Database

5
4 min read
SQL : JSON Datatype

SQL : JSON Datatype

6
4 min read
SQL : Internal Functions

SQL : Internal Functions

3
4 min read
SQL : Date/ Time and TimeStamps

SQL : Date/ Time and TimeStamps

2
3 min read
SQL : Arrays

SQL : Arrays

2
5 min read
SQL : Sequences

SQL : Sequences

2
1 min read
SQL : User Defined Datatypes

SQL : User Defined Datatypes

2
3 min read
SQL : DataTypes

SQL : DataTypes

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

SQL Query into Pandas DataFrame - Part 2

2
1 min read
Migration from Mssqlserver to Mongodb for Developers

Migration from Mssqlserver to Mongodb for Developers

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

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

1
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

8 1
1 min read
SQL Injection 101

SQL Injection 101

10 2
5 min read
UUID or cached sequences?

UUID or cached sequences?

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

SQL Basics: INNER JOINs vs LEFT JOINs

4
3 min read
Beware the Performance Dangers of MySQL Views

Beware the Performance Dangers of MySQL Views

24 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

2
4 min read
Redshift es compatible con vistas materializadas!

Redshift es compatible con vistas materializadas!

2
2 min read
CockroachDB Grants and Schemas explained

CockroachDB Grants and Schemas explained

5
10 min read
SQL Performance - pagination scalability

SQL Performance - pagination scalability

3
1 min read
loading...