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.

Transposit

May 7 '19

Superglue for Gaps in Your AWS Infrastructure — automation scripts using SQL and Javascript

#devops #lambda #sql #aws

4 min read

Uku Täht

May 3 '19

How to store ‘last seen’ for users in Phoenix

#elixir #sql #postgres #ecto

2 min read

Lenique Noralez

Apr 8 '19

DBMS For Application Development: SQL (Structured Query Language)

#sql #database #softwaredevelopment #beginners

4 min read

Mar 21 '19

Fewer Dashboards, More Analysis

#data #analytics #sql #bi

5 min read

Transposit

Mar 15 '19

The Life Changing Magic of Migrating Github repositories with Transposit

#softwaredevelopment #github #sql #api

4 min read

Transposit

Mar 7 '19

SQL order from API chaos

#serverless #javascript #api #sql

3 min read

Feb 28 '19

Q&A with Helen Anderson, BI Data Analyst and Technical Consultant

#data #beginners #sql #bi

6 min read

Hong duc

Jan 12 '19

When query db should I check if data exists first then select it ?

#discuss #sql #bestpractice

1 min read

Jan 8 '19

Oracle and SQLite compiler are now available in SqlKata

#sql #sqlite #oracle #c

1 min read

Jon Luke Harvey

Nov 29 '18

What is SQL injection?

#security #websites #programming #sql

2 min read

Katie

Nov 2 '18

Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

#explainlikeimfive #discuss #sql #french

6 min read

jreighley

Oct 6 '18

Dynamic SQL cheatsheet

#sql #ibmi #clojure

2 min read

Oct 14 '15

Check if temp table exists in SQL

#sql

1 min read

randysims

Aug 28 '18

SQL Server 2016’s STRING_SPLIT

#sqlserver #functions #sqlserver2016 #sql

1 min read

Jun 18 '18

Implementing Soft-Delete in pure MySQL

#programming #database #sql #softdelete

3 min read

Devart Software

May 17 '18

More Secure and Productive Database and Code Development in Updated SQL Complete

#sql #ssms #addin #database

1 min read

Mary Thengvall for Nylas

Feb 8 '18

Nylas is Hiring a Senior Software Engineer

#hiring #python #sql #womenintech

2 min read

randysims

Sep 12 '18

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

#sqlserver #sets #sql

1 min read

Christine Spang for Nylas

Nov 22 '17

Nylas is Hiring a Senior Software Engineer

#hiring #python #sql #womenintech

2 min read

Mar 27 '14

Check if type exists in MSSQL

#sql #mssql #snippet

1 min read

Feb 18 '14

Find column from all tables

#sql

1 min read

Jan 31 '13

Connecting to SQL over TCP/IP with Entity Framework

#entityframework #csharp #sql

1 min read

Matt Davis

Nov 5 '18

PostgreSQL: Efficient Queries - Indexing

#postgres #sql #tutorial

1 min read

Nov 22 '11

MySQL Global Vars wait_timeout & max_connections

#sql

1 min read

Jan 20 '11

MySql Version "Correlated Sub-Queries and Group By Unions"

#sql

1 min read

loading...