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.

Nikolas Burk for Prisma

Feb 26 '20

How to set up a free PostgreSQL database on Heroku

#postgres #heroku #database #sql

3 min read

Kay Sauter

Mar 7 '20

Introduction into Window Functions on SQL Server

#sql #tutorial

4 min read

David Hunt

Mar 6 '20

Using SQL's TRIM and REPLACE to tidy up your data

#sql

3 min read

justin gage for Retool

Mar 4 '20

Formatting and dealing with dates in SQL

#sql #dates #formatting

11 min read

Davide Mauri for Microsoft Azure

Mar 4 '20

An amazingly simple solution for Mobile Apps to sync with the Cloud using Change Tracking API

#webdev #beginners #sql #programming

8 min read

Maria Gabriela Oliva

Mar 2 '20

[PT-BR] Funcionalidades do DBeaver

#dba #management #sql #database

2 min read

Mar 5 '20

Modern data practice and the SQL tradition

#todayilearned #database #sql

2 min read

Mike Pendon (Zym)

Mar 1 '20

C#: Bulk Operations for .NET Core (BulkDelete, BulkInsert, BulkMerge, BulkUpdate) is now very simple with RepoDb ORM

#csharp #dotnet #tutorial #sql

7 min read

Gabriel Pickard

Feb 26 '20

Data Science is dying out

#datascience #machinelearning #sql

2 min read

Feb 27 '20

Joining database tables

#sql

4 min read

Feb 28 '20

Populate Blazor Dropdown Menu from EF Core Lookup Table

#csharp #dotnet #sql

3 min read

Forbes Lindesay

Feb 21 '20

Storing JSON in Postgres using Node.js

#postgres #node #sql #javascript

3 min read

Davide Mauri for Microsoft Azure

Feb 21 '20

10K RPS REST API with Azure SQL, Dapper and JSON

#dotnet #sql #azure #webdev

4 min read

Benjamin Finkel

Feb 21 '20

Embracing the Power of the Self-Referential Join

#sql #database #beginners

4 min read

Feb 21 '20

How to: use jsonb_set function in PostgreSQL

#postgres #jsonb #sql #example

1 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.