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.

Ola Sk

Jan 5 '20

Database normalization may be harmful to efficiency on large scale analytics projects.

#database #bigdata #sql #analysis

2 min read

Jan 3 '20

SQL and the Soup Kitchen

#sql

1 min read

Mike Pendon (Zym)

Jan 2 '20

Creating a C# Repository in .NET Core using RepoDb

#csharp #dotnet #sql #beginners

5 min read

Maximo Guerrero

Dec 31 '19

Simple Queue in PostgreSQL

#postgres #sql

2 min read

Dec 31 '19

An Example to Demonstrate The Vulnerability of SQL Injection and Its Prevention in Oracle

#oracle #plsql #sql #writing

3 min read

Camilo

Dec 31 '19

Using Single and Multiline Comments

#sql #tricks

1 min read

Rob Reid

Dec 30 '19

CockroachDB via Crystal ... In under 50 lines

#database #sql #crystal #api

6 min read

Mike Pendon (Zym)

Dec 30 '19

RepoDb - a hybrid ORM library for .NET.

#csharp #dotnet #sql #orm

2 min read

Moshe Zada

Dec 30 '19

Elasticsearch Comrade Part #1 - SQL Queries

#elasticsearch #elastic #sql #vue

1 min read

Rumesh Madhusanka

Dec 28 '19

When to use/not use an ORM

#discuss #sql #orm

1 min read

Dec 28 '19

🐢 7 Steps to SQL Optimizationn Mastery

#sql

3 min read

Dec 27 '19

jOOQ - a short guide

#java #sql #jooq #database

8 min read

Dec 26 '19

Codeigniter custom helper functions which will increase your productivity

#php #sql #codeigniter #cheatcodes

2 min read

Michel

Dec 23 '19

Updating a table from another table

#sql #snippet

1 min read

Mervyn Lee

Dec 20 '19

Understanding SQL Server Isolation Levels through example

#sql

6 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.