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.
Quick-start SQL Server 2019 in Docker

Quick-start SQL Server 2019 in Docker

4
Comments
1 min read
Popular string functions in MySQL - Replace and Reverse
Cover image for Popular string functions in MySQL - Replace and Reverse

Popular string functions in MySQL - Replace and Reverse

4
Comments
1 min read
Using SQL or NoSQL
Cover image for Using SQL or NoSQL

Using SQL or NoSQL

7
Comments 3
1 min read
Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

4
Comments
4 min read
Popular string functions in MySQL - CONCAT and SUBSTRING
Cover image for Popular string functions in MySQL - CONCAT and SUBSTRING

Popular string functions in MySQL - CONCAT and SUBSTRING

5
Comments
2 min read
Programming with SQLite

Programming with SQLite

5
Comments
2 min read
TypeORM - Multiple DB Calls vs Single DB Call
Cover image for TypeORM - Multiple DB Calls vs Single DB Call

TypeORM - Multiple DB Calls vs Single DB Call

15
Comments
6 min read
Can I get a dash of regular expression in my KQL?
Cover image for Can I get a dash of regular expression in my KQL?

Can I get a dash of regular expression in my KQL?

7
Comments
1 min read
3 small tips to make your SQL Server experience easier

3 small tips to make your SQL Server experience easier

8
Comments
5 min read
How To Find Unused Stored Procedures In SQL Server

How To Find Unused Stored Procedures In SQL Server

7
Comments
3 min read
Postgres Full Text Search

Postgres Full Text Search

4
Comments
5 min read
SQL Review - Useful queries for mySQL
Cover image for SQL Review - Useful queries for mySQL

SQL Review - Useful queries for mySQL

9
Comments
1 min read
What is SQL - Part 4
Cover image for What is SQL - Part 4

What is SQL - Part 4

7
Comments
7 min read
Building a Hybrid SQL + NoSQL E-Commerce Data Model

Building a Hybrid SQL + NoSQL E-Commerce Data Model

22
Comments
7 min read
No-Code: "It's a Trap!"
Cover image for No-Code: "It's a Trap!"

No-Code: "It's a Trap!"

8
Comments
9 min read
Kalman Filtering in SQL
Cover image for Kalman Filtering in SQL

Kalman Filtering in SQL

9
Comments
6 min read
Inside Presto Optimizer
Cover image for Inside Presto Optimizer

Inside Presto Optimizer

7
Comments
9 min read
How to output raw SQL with filled parameters in TypeORM?
Cover image for How to output raw SQL with filled parameters in TypeORM?

How to output raw SQL with filled parameters in TypeORM?

16
Comments 3
2 min read
What’s an Example of Good E-Commerce Database Design?
Cover image for What’s an Example of Good E-Commerce Database Design?

What’s an Example of Good E-Commerce Database Design?

43
Comments 2
8 min read
KnexJS: how to convert a SQL join with aliases and ordered by values from another table
Cover image for KnexJS: how to convert a SQL join with aliases and ordered by values from another table

KnexJS: how to convert a SQL join with aliases and ordered by values from another table

2
Comments
1 min read
I analyzed my six years of food deliveries
Cover image for I analyzed my six years of food deliveries

I analyzed my six years of food deliveries

11
Comments 7
5 min read
How Do You Design a Shopping Cart Database for E-Commerce?
Cover image for How Do You Design a Shopping Cart Database for E-Commerce?

How Do You Design a Shopping Cart Database for E-Commerce?

50
Comments 3
8 min read
What to do once you reach max integer value for an auto incremented column in Rails

What to do once you reach max integer value for an auto incremented column in Rails

5
Comments 2
2 min read
Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

6
Comments
3 min read
What is SQL - Part 3
Cover image for What is SQL - Part 3

What is SQL - Part 3

4
Comments
6 min read
loading...