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.

Vladimir Ozerov

Apr 16 '21

Custom traits in Apache Calcite

#calcite #sql #database

7 min read

Apr 27 '21

Combining SQL outer joins with inner joins

#sql

2 min read

Arctype Team for Arctype

Apr 26 '21

Getting started with PostgreSQL Set Operators

#postgres #sql #database #tutorial

4 min read

Apr 25 '21

Quick-start SQL Server 2019 in Docker

#sql #docker

1 min read

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

loading...