select * from SQL

3 min read

Gus Pear 🍐

Dec 13 '22

How to work with JSON data on SQL Server

#webdev #sql #database #programming

8

4 min read

Jake McLelland

Dec 13 '22

Handling Duplicate Records

#sql #database #devjournal

3 min read

Franck Pachot for YugabyteDB

Dec 13 '22

SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

#sql #macro #udf #views

4 min read

kaede

Dec 13 '22

SQL 基礎 Part 01 -- PostgreSQL サーバーを docker-compose で起動する

#sql #postgres #docker

2 min read

Dave Parsons

Dec 12 '22

Intro to Postgres Row-Level Security

#supabase #postgres #sql #serverless

17

4 min read

Keyhole Software for Keyhole Software

Dec 12 '22

Monitoring SQL Server Agent Jobs with Spring Batch

#java #springbatch #sql #modernization

4 min read

Anne Quinkenstein

Dec 12 '22

SQL Cheet Sheat

#sql #beginners

2 min read

Dave Parsons

Dec 12 '22

Advanced Postgres Row Level Security

#supabase #postgres #serverless #sql

6 min read

Dmitry Romanoff

Dec 11 '22

How to check if the PostgreSQL tables of the same structure have the identical data using aggregated hash and md5?

#postgres #sql #devops #database

2 min read

Davide Mauri for Microsoft Azure

Dec 11 '22

Advent of Code - Day 10

#sql #beginners #programming #adventofcode

4 min read

Amit Tiwary

Dec 10 '22

How sql engine handle join internally - part 2

#sql #mysql #database

15

3 min read

Teemu

Dec 10 '22

Forget about migrations and use SQLSugar

#python #sql #sqlalchemy #migrations

2 min read

Slava Rozhnev

Dec 9 '22

SQL Server 2022: Logical Functions - GREATEST & LEAST

#sql #tsql #tutorial

1 min read

Walid Bouladam

Dec 8 '22

Database Normalisation

#database #beginners #sql

27

4 min read

Franck Pachot for YugabyteDB

Dec 8 '22

What is a "truly distributed UDF" ?

#yugabytedb #postgres #udf #sql

4 min read

Franck Pachot for YugabyteDB

Dec 7 '22

Partial Index as an approximate Count(*) Materialized View

#yugabytedb #postgres #sql #aggregate

3 min read

Dec 6 '22

Arrays in SQL? Yay or Nay?

#sql #postgres #database #design

2 min read

Gerald Venzl 🚀

Dec 6 '22

Percentage calculations using SQL Window Functions

#sql #oracle #programming #tutorial

6 min read

Slava Rozhnev

Dec 5 '22

MySQL 8: short syntax for select all

#news #sql #mysql

1 min read

Amit Tiwary

Dec 3 '22

How sql engine handle join internally-part 1

#sql #database

26

3 min read

Isabelle M.

Dec 4 '22

Why do SQL Server views need refreshing?

#sql #beginners #programming

2 min read

Munavvar Sinan

Dec 3 '22

OpenAI SQL Query generator with GPT-3 and Nextjs

#nextjs #openai #sql #gpt3

9

6 min read

Franck Pachot for YugabyteDB

Dec 2 '22

Scalable Job Queue in SQL (YugabyteDB)

#yugabytedb #sql #queue #scalability

21

5 min read

Maria Yudina

Dec 3 '22

How to add a condition in SQL with GROUP BY

#sql #beginners

1 min read

Davide Mauri for Microsoft Azure

Dec 2 '22

Advent of Code - Day 2

#sql #beginners #programming #adventofcode

4 min read

Davide Mauri for Microsoft Azure

Dec 1 '22

Advent of Code - Day 1

#sql #beginners #programming #adventofcode

11

4 min read

Davide Santangelo

Dec 1 '22

SQL Join explained!

#sql #webdev #database

2 min read

Dmitry Romanoff

Dec 1 '22

Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide

#cpu #postgres #database #sql

11 min read

Sarang S. Babu

Nov 30 '22

What is SQL Injection and How to prevent it?

#sql #cybersecurity #database #security

11

10 min read

Jungle Sven

Nov 19 '22

5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

#python #database #sql #nosql

5 min read

Franck Pachot for YugabyteDB

Nov 30 '22

The best indexes for an execution plan that never gets (too) wrong

#sql #database #yugabytedb #optimizer

15 min read

ente

Nov 30 '22

Using Postgres as a task queue for rowdy Gophers

#postgres #sql #go #tutorial

13 min read

Slava Rozhnev

Nov 28 '22

Online PHP & SQL sandbox with ChatGPT support

#sql #php #sandbox #playground

11

2 min read

Yaroslav Polyakov

Nov 25 '22

sql-export - create .md / .json files from database content

#hugo #json #markdown #sql

2 min read

Glaucia Lemos for Microsoft Azure

Nov 23 '22

Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

#prisma #azure #sql #javascript

37

2 min read

Bek Brace

Nov 23 '22

SQL Vs NoSQL

#sql #database #beginners #career

1 min read

Frits Hoogland for YugabyteDB

Nov 22 '22

PostgreSQL and YugabyteDB partitioning and indexes

#postgres #yugabytedb #performance #sql

7 min read

Leslie Gyamfi

Nov 22 '22

ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

#datascience #postgres #sql #database

4 min read

Erika for Tinybird

Nov 22 '22

ClickHouse Fundamentals: Part 2

#database #clickhouse #performance #sql

4 min read

OSS Insight

Nov 22 '22

How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database

#opensource #distributedsystems #database #sql

9 min read

nchika

Nov 10 '22

sqly - execute SQL against CSV / TSV / LTSV / JSON with shell

#showdev #sql #go

2 min read

mkdev.me for mkdev

Nov 10 '22

Cloud Scheduler to stop a Cloud SQL database

#cloud #scheduler #sql

4 min read

Frits Hoogland for YugabyteDB

Nov 19 '22

PostgreSQL do different equality predicates make a difference?

#yugabytedb #postgres #performance #sql

9

2 min read

WISDOMUDO

Nov 19 '22

NHOST: AN INTRODUCTION TO BACK-END AS A SERVICE.

#javascript #beginners #sql #database

5 min read

Paige Niedringhaus

Nov 20 '22

Create Upsert Yourself for Amazon Redshift Databases

#sql #postgres #aws

6 min read

Massimiliano Donini

Nov 17 '22

EF Core 7 is here - Welcome typed entity id 🍾

#dotnet #entityframework #ddd #sql

5 min read

midir99

Nov 7 '22

Deja de escribir código SQL dentro de código Go, ¡la solución está aquí!

#showdev #go #sql #spanish

2 min read

Franck Pachot for YugabyteDB

Nov 17 '22

YugabyteDB auto-sharding (showing tablet size with Grafana)

#yugabytedb #distributed #sql #sharding

8 min read

Gülsen Keskin

Nov 17 '22

Eğlenceli SQL Kaynakları 🙂

#sql

1 min read

realNameHidden

Nov 17 '22

Weather Observation Station 17 Hackerrank Solution

#sql #hackerrank

1 min read

Roy

Nov 16 '22

SQL vs NoSQL

#sql #database #beginners

14

4 min read

cybo-neutron

Nov 16 '22

Basics of PostgreSQL

#postgres #sql #database

9

2 min read

Mike Houngbadji

Nov 16 '22

Apache Spark SQL: CTAS USING CSV with specific delimiter

#sql #spark #database #tips

1 min read

Justin Saborouh

Oct 26 '22

SQL and Table Relationships

#sql #ruby #database #datascience

3 min read

Franck Pachot for YugabyteDB

Nov 15 '22

Flashback query in YugabyteDB

#yugabytedb #flashback #query #sql

6 min read

realNameHidden

Nov 15 '22

Weather Observation Station 15 Hackerrank Solution

#sql #hackerrank

1 min read

FakeStandard

Nov 14 '22

使用 SQL 產生流水單號

#sql

2 min read

Shoubhit Dash

Nov 12 '22

Typesafe Database Queries on the Edge

#typescript #sql #webdev

18

6 min read

The Dream Coding

Nov 13 '22

How to create Stored Procedure in MySQL

#mysql #sql #bigdata #database