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.

Bruno Vezoli for Rootstrap

Jul 16 '20

A Take on Empowering ActiveRecord

#rails #activerecord #opensource #sql

3 min read

Jul 19 '20

Inner Join Tables in SQL

#beginners #sql

3 min read

Kaylan Stock for Harper

Jul 15 '20

LMDB Deep Dive: Interview with a CTO on using the Open Source Key Value Store

#techtalks #database #showdev #sql

13 min read

ScaleGrid for ScaleGrid

Jul 17 '20

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

#postgres #json #sql #database

30 min read

Jul 17 '20

Efficient INSERT MULTIPLE with Postgres

#sql #database #postgres

4 min read

Jul 16 '20

HarperDB: A NewSQL Database.

#database #nosql #sql #webdev

5 min read

Sharan Kumar Paratala Rajagopal

Jul 16 '20

Using SUBSTR and INSTR functions in ORACLE PLSQL

#substring #plsql #sql #instr

1 min read

OM

Jul 5 '20

When to choose NoSQL over SQL?

#sql #nosql #database #architecture

2 min read

Jul 15 '20

How to Query a JSON in PostgreSQL

#sql #database #postgres #tutorial

3 min read

Sam Hill for Touchlab

Jul 14 '20

Multiplatform Encryption with SQLDelight and SQLCipher

#kotlin #sql #android #ios

3 min read

John Baker

Jul 14 '20

Extracting SQL code from SSIS dtsx packages with Python lxml

#python #ssis #sql #lxml

3 min read

Jul 13 '20

Getting started with our PostgreSQL database

#node #database #sql #webdev

4 min read

Jul 13 '20

Snowflake Field Notes

#sql #datascience #database

12 min read

Colin Fay

Jul 17 '20

clientsdb - A docker image with clients comments

#rstats #postgres #sql

2 min read

Stephen Goldberg for Harper

Jul 10 '20

Deep Dive: NewSQL Databases

#discuss #database #sql #architecture

8 min read

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