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.

Jul 20 '20

Advanced SQLAlchemy Features You Need To Start Using

#python #sql #postgres #database

10 min read

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

kim

Jul 18 '20

PL/SQL Cheat Sheet

#sql #codenewbie

1 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 16 '20

Why is SQL injection still a thing?

#sql #database #csharp #dotnet

1 min read

Katie

Jul 15 '20

PL/SQL Nested Queries

#database #sql #oracle #tips

5 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

Sharan Kumar Paratala Rajagopal

Jul 12 '20

Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

#transpose #sql #oracle #pivot

1 min read

Jul 12 '20

Using MySQL Together With Go

#go #sql #tutorial #video

1 min read

Jul 11 '20

Data Architecture as a Utility Tool

#sql #database #datascience #architecture

10 min read

Jul 10 '20

Querying CSV files in AWS S3 from Go, using SQL

#aws #go #sql

5 min read

Jul 10 '20

Oracle SQL Analytic Functions - Part 1

#database #oracle #sql #tutorial

10 min read

Maverick

Jul 8 '20

When to use NoSQL over SQL ?

#watercooler #sql #datascience #career

2 min read

loading...