DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL
scalegridio profile

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

#postgres #json #sql #database
24
Comments 1
30 min read
HarperDB: A NewSQL Database.
chandan24 profile

HarperDB: A NewSQL Database.

#database #nosql #sql #webdev
38
Comments 1
5 min read
Using SUBSTR and INSTR functions in ORACLE PLSQL
prsharankumar profile

Using SUBSTR and INSTR functions in ORACLE PLSQL

#substring #plsql #sql #instr
4
Comments
1 min read
When to choose NoSQL over SQL?
ombharatiya profile

When to choose NoSQL over SQL?

#sql #nosql #database #architecture
210
Comments 22
2 min read
How to Query a JSON in PostgreSQL
rupeshpadhye profile

How to Query a JSON in PostgreSQL

#sql #database #postgres #tutorial
8
Comments
3 min read
Multiplatform Encryption with SQLDelight and SQLCipher
samhill303 profile

Multiplatform Encryption with SQLDelight and SQLCipher

#kotlin #sql #android #ios
19
Comments
3 min read
Extracting SQL code from SSIS dtsx packages with Python lxml
bakerjd99 profile

Extracting SQL code from SSIS dtsx packages with Python lxml

#python #ssis #sql #lxml
11
Comments 1
3 min read
Getting started with our PostgreSQL database
neisha1618 profile

Getting started with our PostgreSQL database

#node #database #sql #webdev
8
Comments
4 min read
Snowflake Field Notes
mattarderne profile

Snowflake Field Notes

#sql #datascience #database
8
Comments
12 min read
clientsdb - A docker image with clients comments
colinfay profile

clientsdb - A docker image with clients comments

#rstats #postgres #sql
8
Comments
2 min read
Deep Dive: NewSQL Databases
stephengoldberg profile

Deep Dive: NewSQL Databases

#discuss #database #sql #architecture
69
Comments 3
8 min read
Transpose rows to columns in Oracle SQL using Oracle PIVOT clause
prsharankumar profile

Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

#transpose #sql #oracle #pivot
12
Comments
1 min read
Data Architecture as a Utility Tool
mattarderne profile

Data Architecture as a Utility Tool

#sql #database #datascience #architecture
5
Comments
10 min read
Querying CSV files in AWS S3 from Go, using SQL
mihaichiorean profile

Querying CSV files in AWS S3 from Go, using SQL

#aws #go #sql
11
Comments
5 min read
Oracle SQL Analytic Functions - Part 1
markbdsouza profile

Oracle SQL Analytic Functions - Part 1

#database #oracle #sql #tutorial
13
Comments
10 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.