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.

Pacharapol Withayasakpunt

May 7 '20

What is the best way store column metadata in SQLite (like, is JSON or is Date)

#help #sqlite #sql #database

1 min read

May 6 '20

Jupyter Notebooks + IBMi

#jupyer #python #ibmi #sql

4 min read

Jay Gordon for Microsoft Azure

May 4 '20

Azure SQL and Site Reliability

#beginners #azure #database #sql

8 min read

Pacharapol Withayasakpunt

May 3 '20

What SQLite CAN actually do

#discuss #sqlite #sql #database

3 min read

Paul Delcogliano

May 3 '20

Avoid This Mistake When Restoring a TDE Protected Database to a New Server

#sql #tde #restore #backup

3 min read

May 1 '20

Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

#distributedsystems #database #sql

5 min read

Apr 29 '20

Getting query performance stats with PostgreSQL

#postgres #database #sql #monitoring

6 min read

May 1 '20

Exploring Column Families in CockroachDB

#database #distributed #sql #video

2 min read

May 1 '20

How to Automate Continuous Database Backup and Restore

#devops #sql #database #azure

3 min read

TJ Wright

May 1 '20

A Primer on Relational Databases for Beginners by a Beginner

#sql #backend #codenewbie #beginners

8 min read

Avthar Sewrathan for Tiger Data (Creators of TimescaleDB)

Apr 30 '20

How to Build More Accurate Grafana Trend Lines: Give Perspective with Series-Override

#showdev #sql #tutorial #devops

4 min read

Konstantin Triger

Apr 29 '20

Hierarchical Queries in SQL with C# and Entity Framework Core

#sql #csharp #efcore #dotnet

1 min read

Apr 29 '20

A workout routine with Oracle DEV GYM

#java #programming #productivity #sql

1 min read

Rushdi Baderoen

Apr 28 '20

SQL DB Backups to Azure Storage with Powershell

#powershell #azure #sql #devops

2 min read

Vincent

Apr 26 '20

How to do upserts in Knex.js (PostgreSQL)

#knex #upserts #insert #sql

3 min read

Apr 25 '20

MySQLDump.js

#showdev #mysql #backup #sql

1 min read

Apr 23 '20

Sending a Text Message with SQL (IBMi)

#ibmi #sql #twiliohackathon

4 min read

Apr 21 '20

Use Dash to Build BigQuery-Connected Python Web Apps

#python #sql #webdev #dbapi

3 min read

Paul Delcogliano

Apr 21 '20

Remove Duplicate Records via SQL Server's Rank Function

#sql #duplicate #rank

3 min read

chair

Apr 20 '20

Translate rails query to raw sql in rails console

#todayilearned #ruby #rails #sql

1 min read

Krishankant Ray

Apr 19 '20

CSV to SQL import using Node, Express and React

#react #node #express #sql

3 min read

David Kanekanian

Apr 15 '20

E5 - Save Order in Database

#php #sql #tutorial

3 min read

Angel Daniel Munoz Gonzalez

Apr 14 '20

Migrondi, Simple SQL migrations tool

#sql #dotnet #fsharp #tool

5 min read

Apr 13 '20

Getting Started with MariaDB using Docker and Node.js

#mariadb #docker #node #sql

4 min read

Apr 12 '20

How Often Do You Dream In Code?

#discuss #webdev #python #sql

1 min read

loading...