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.

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

Dec 19 '19

For the 1024 time – DateTime has no format!

#csharp #sql #database #datetime

2 min read

Dec 17 '19

ORM vs Query Builders vs Raw SQL

#discuss #orm #sql

2 min read

Hasura for Hasura

Dec 19 '19

GraphQL with Postgres views and materialized views

#graphql #postgres #sql #tutorial

5 min read

Dec 19 '19

6 Common Sequelize Queries Explained in SQL

#node #javascript #sql #database

4 min read

Dec 18 '19

How I passed 70-761 T-SQL exam

#sql #career #certification #microsoft

3 min read

Dec 15 '19

How to Load Data into an SQL database: From simple inserts to bulk loads

#sql #database #postgres #datascience

3 min read

Dec 15 '19

Does WordPress database architecture need improvement?

#discuss #wordpress #sql #database

1 min read

Chidiebere Ogujeiofor

Dec 13 '19

SQL Subqueries in action

#postgres #database #sql #subquery

8 min read

Dec 11 '19

Understanding MySQL Index Basics

#database #mysql #sql #developer

2 min read

Suresh Mohan for Syncfusion, Inc.

Dec 12 '19

8 Tips and Tricks for Writing the Best Queries in LINQ to Entities

#dotnet #csharp #sql #productivity

8 min read

Dec 10 '19

A more controllable random string generator function for SQL Server

#sql #database

3 min read

Ruairidh W McHardy

Dec 10 '19

Stop using offset pagination

#pagination #sql #database #data

3 min read

Lorraine for Next Tech

Dec 10 '19

Cleaning and Transforming Data with SQL

#sql #dataanalysis #beginners #tutorial

6 min read

Rob Reid

Dec 9 '19

CockroachDB Demo Locations

#database #sql #cockroachdb

3 min read

Rob Reid

Dec 9 '19

Geo-partitioning. No column? No problem!

#database #sql #cockroachdb

3 min read

J. Guilherme Routar de Sousa for Jscrambler

Dec 9 '19

The Data Processing Holy Grail? Row vs. Columnar Databases

#database #sql #mongodb #postgres

12 min read

Dec 6 '19

SQL Vs NoSQL – Which Is Best For You?

#sql

3 min read

Dec 3 '19

Airbnb’s Airflow Versus Spotify’s Luigi

#database #sql #python #devops

7 min read

Jonathan Sundqvist

Dec 4 '19

Creating a materialized view with SQL procedures

#sql #mysql

3 min read

Nicolas Hourcard

Dec 2 '19

QuestDB - fast relational time-series DB, zero GC java

#database #java #opensource #sql

1 min read

Chidiebere Ogujeiofor

Dec 13 '19

Whats WITH CTE

#postgres #database #sql

9 min read

Nov 30 '19

SQL: Outer Joins

#sql #programming #postgres #database

4 min read

loading...