select * from SQL

6 min read

Shivam Singh

Jan 6 '23

SQL Commands Cheat Sheet

#sql #mysql #database #cheat

11 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jan 6 '23

Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

#yugabytedb #postgres #distributed #sql

3 min read

Theophilus Kolawole

Jan 6 '23

Common mistakes to avoid when writing SQL code

#sql #webdev

4 min read

Asif

Jan 4 '23

Boost Your Query Performance with Function-Based Indexes in PostgreSQL

#postgres #sql #webdev #database

1 min read

Sandip Basnet

Jan 3 '23

Create user with read only permission in PostgreSQL

#postgres #permission #sql #roles

1 min read

Anatolii Kozlov

Dec 31 '22

One-page Database cheat sheet

#interview #cheatsheet #database #sql

1 min read

Thomas Karner

Dec 30 '22

Mermerd - Generate your ERD blazingly fast

#productivity #opensource #database #sql

2 min read

Leandro Ramos

Dec 30 '22

The basic of the advanced SQL queries: Tuning

#sql #database #community #performance

4 min read

NebulaGraph

Dec 29 '22

Using NebulaGraph Importer to Import Data into NebulaGraph Database

#database #opensource #graphdatabase #sql

5 min read

jbx1279

Dec 29 '22

Beyond ORM and Stored Procedures

#sql #java #programming #database

12 min read

Arafat

Dec 28 '22

SQL cheat sheet/crash course

#sql #webdev #programming #beginners

4 min read

Chris Farris for AWS Community Builders

Dec 27 '22

Mapping your AWS attack surface

#sql #cloudsecurity #opensource #aws

6 min read

ChunTing Wu

Dec 26 '22

Playing Window Function in Postgres

#sql #tutorial #bigdata #datascience

4 min read

jbx1279

Dec 26 '22

Open-source SPL that can execute SQL without RDB

#sql #database #opensource #java

11 min read

Amit Tiwary

Dec 24 '22

How SQL engine implement the isolation levels in MySQL

#mysql #database #sql

9

3 min read

Rick Delpo

Dec 23 '22

To SQL or to NoSQL (with a simple NoSQL Example)

#sql #webdev #javascript #tutorial

11 min read

Adrien Olivon

Dec 23 '22

Data Segregation with PostgreSQL

#sql #postgres #monolith

9 min read

Tifani Dermendzhieva for Zone 2 technologies Ltd.

Dec 23 '22

TOP 5 WEBSITES TO LEARN SQL

#sql #learn #top #beginners

3 min read

Timothy Spann. 🇺🇦

Dec 10 '22

Building Streaming Applications with Cloudera SQL StreamBuilder and Apache Pulsar

#sql #flink #opensource

5 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 20 '22

A very short demo on updates in YugabyteDB

#yugabytedb #postgres #sql #distributed

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 19 '22

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

#oracle #sql #postgres #compatibility

10 min read

kaede

Dec 18 '22

SQL 基礎 Part 03 -- docker-compose で立てたコンテナで立ち上げ時に DB と全権力ユーザーを作成して、外部からログインする

#sql #docker

2 min read

Luiz Zulian

Dec 16 '22

'; SQL_Injection ( ) ;--

#security #hacker #pentest #sql

7 min read

Will Velida

Dec 16 '22

Working with Azure SQL Triggers in Azure Functions

#azure #csharp #sql #serverless

21

7 min read

Davide Mauri for Microsoft Azure

Dec 5 '22

Advent of Code - Day 4

#sql #programming #beginners #adventofcode

3 min read

Davide Mauri for Microsoft Azure

Dec 4 '22

Advent of Code - Day 3

#sql #beginners #programming #adventofcode

6 min read

Niko Krvavica for Memgraph

Dec 15 '22

Why Are SQL Databases Outdated for the Real-Time Recommendation Engines

#memgraph #sql #database #graphdatabase

9 min read

cenan ozen for DbModeller.net

Dec 14 '22

Types of SQL Joins

#sql #tutorial #database

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 14 '22

INSERT ON CONFLICT returning old values

#postgres #yugabytedb #sql #duplicate

3 min read

Gus Pear 🍐

Dec 13 '22

How to work with JSON data on SQL Server

#webdev #sql #database #programming

10

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 13 '22

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

#sql #macro #udf #database

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

7

4 min read

Dave Parsons

Dec 12 '22

Advanced Postgres Row Level Security

#supabase #postgres #serverless #sql

6 min read

Kovid Rathee

Dec 12 '22

SQL extensions for time series data in QuestDB part II

#database #tutorial #opensource #sql

8 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 Distributed PostgreSQL Database

Dec 8 '22

What is a "truly distributed UDF" ?

#yugabytedb #postgres #udf #sql

7

4 min read

66np

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

37

3 min read

Isabelle M.

Dec 4 '22

Why do SQL Server views need refreshing?

#sql #beginners #programming

10

2 min read

Munavvar Sinan

Dec 3 '22

OpenAI SQL Query generator with GPT-3 and Nextjs

#nextjs #openai #sql #gpt3

13

6 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

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

7

2 min read

Dmitry Romanoff

Dec 1 '22

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

#cpu #postgres #database #sql

9

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 Distributed PostgreSQL Database

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