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 4 '20

Don't miss this Data for Good panel at MS Create: Data

#sql #firstpost #azure #mscreate

1 min read

Johnß

Dec 4 '20

UPDATE … FROM for database normalisation

#postgres #sql #normalisation

1 min read

sabrinasuarezarrieta

Dec 4 '20

Example of Stored Procedures in PostgreSQL

#postgres #sql #beginners

2 min read

Dec 4 '20

Move your sql database files to a separate hard drive

#sql #database

3 min read

Dec 4 '20

Built in String Functions in SQL

#sql #mssqlserver

2 min read

Davide Mauri for Microsoft Azure

Dec 3 '20

Autoscaling Azure SQL Hyperscale

#sql #azure #cloud #database

10 min read

Dec 3 '20

DB Administration tools on Linux

#discuss #linux #database #sql

1 min read

Dec 2 '20

Convert user story of a simple library to ER and Relational diagrams in less than 10mins

#database #sql #webdev #codenewbie

2 min read

Supabase for Supabase

Dec 1 '20

Supabase: nine months of building.

#postgres #javascript #opensource #sql

2 min read

Dec 8 '20

Advent Of Code 2020 in SQL - Day 1: "Report Repair"

#adventofcode #sql #plsql

4 min read

Dec 1 '20

DRYing up Rails Scopes and Instance Methods

#ruby #rails #sql #dry

4 min read

Pacharapol Withayasakpunt

Nov 19 '20

Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

#discuss #sql #sqlite

1 min read

Nov 29 '20

Office Hours With A Data Consultant To Develop Your Data Analytics Strategy For 2021

#datascience #database #sql #startup

8 min read

🚀 Vu Dao 🚀

Nov 28 '20

SQLPad - Quick Start With Docker

#sql #docker #devops #postgres

2 min read

Nov 28 '20

Rails SQL Injections

#rails #sql #performance

5 min read

Margo McCabe for Harper

Nov 23 '20

HarperDB vs. MongoDB vs. PostgreSQL

#database #sql #webdev #programming

6 min read

Nov 27 '20

Exporting a sql database from phpmyadmin and copying it to your local machine when you have lots of foreign key constraints

#phpmyadmin #sql #mysql

1 min read

Johnß

Nov 26 '20

SQL CROSS JOINs

#sql #postgres #joins

2 min read

Nov 24 '20

Run SQL in Slack

#sql #productivity #database #analytics

2 min read

Franck Pachot for AWS Heroes

Nov 25 '20

DynamoDB PartiQL - part II: SELECT

#aws #dynamodb #partiql #sql

9 min read

Jimmy Guerrero for YugabyteDB

Nov 25 '20

Enabling pgAudit, pgcrypto and scram-SHA-256 in Distributed SQL

#opensource #sql #postgres #security

7 min read

Nov 25 '20

SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database

#sql #oracle #soda #nosql

1 min read

Franck Pachot for AWS Heroes

Nov 24 '20

DynamoDB PartiQL – part I: INSERT

#aws #dynamodb #sql #insert

7 min read

Alejandro Bezdjian

Nov 24 '20

Re-Wheel series part 1 - How does Rails' find_each work?

#ruby #rails #streams #sql

4 min read

Pacharapol Withayasakpunt

Nov 12 '20

varchar(n) - how big should n be?

#help #sql #database

1 min read

loading...