Skip to content

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 to sort posts by relevant, latest, or top.

Jo

Apr 24 '21

Popular string functions in MySQL - Replace and Reverse

#sql #mysql

1 min read

Apr 23 '21

Using SQL or NoSQL

#sql #nosql

1 min read

Apr 23 '21

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

#sql #5days5blogposts

4 min read

Jo

Apr 23 '21

Popular string functions in MySQL - CONCAT and SUBSTRING

#sql #mysql

2 min read

Apr 23 '21

Programming with SQLite

#sql #sqlite #cpp #python

2 min read

Yoshiaki Matsutomo

Apr 23 '21

TypeORM - Multiple DB Calls vs Single DB Call

#node #sql #typescript #database

6 min read

anatdagan

Apr 23 '21

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

#kusto #regex #sql #syntax

1 min read

Apr 22 '21

3 small tips to make your SQL Server experience easier

#sql #5days5blogposts

5 min read

Tim

Apr 22 '21

How To Find Unused Stored Procedures In SQL Server

#sql #programming #codequality

3 min read

May 1 '21

Postgres Full Text Search

#postgres #sql #database

5 min read

Jo

Apr 21 '21

SQL Review - Useful queries for mySQL

#mysql #sql #postgres

1 min read

Marcelo Garbarino

Apr 20 '21

What is SQL - Part 4

#sql #beginners

7 min read

John G for Fabric

Apr 20 '21

Building a Hybrid SQL + NoSQL E-Commerce Data Model

#database #mongodb #sql

7 min read

Arctype Team for Arctype

Apr 20 '21

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

#sql #database #analytics

9 min read

Danny Reed

Apr 20 '21

Kalman Filtering in SQL

#sql #database

6 min read

Vladimir Ozerov

Apr 20 '21

Inside Presto Optimizer

#presto #sql #database #bigdata

9 min read

Krzysztof Szala

Apr 19 '21

How to output raw SQL with filled parameters in TypeORM?

#javascript #typescript #typeorm #sql

2 min read

Shanika Wickramasinghe for Fabric

Apr 18 '21

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

#ecommerce #database #sql #nosql

8 min read

Jakub

Apr 8 '21

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

#help #postgres #sql #javascript

1 min read

Apr 17 '21

I analyzed my six years of food deliveries

#coding #bash #data #sql

5 min read

Shanika Wickramasinghe for Fabric

Apr 16 '21

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

#database #sql #ecommerce

8 min read

Jan Bajena

Apr 16 '21

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

#ruby #rails #sql

2 min read

Apr 5 '21

Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

#dotnet #sql #entityframework

3 min read

Marcelo Garbarino

Apr 15 '21

What is SQL - Part 3

#sql #beginners

6 min read

Cecilia Baggini

Apr 15 '21

Using indexes to speed up queries in PostgreSQL

#sql #postgres

2 min read

loading...