sql.md

July 15, 2021 · View on GitHub

Bookmarks tagged [sql]

www.codever.land/bookmarks/t/sql

SQL vs NoSQL or MySQL vs MongoDB - 21min

https://www.youtube.com/watch?v=ZS_kXvOeQ5Y

SQL or NoSQL? MySQL vs MongoDB? Which database is better? Which one should you use?

UUID or GUID as Primary Keys? Be Careful!

https://tomharrisonjr.com/uuid-or-guid-as-primary-keys-be-careful-7b2aa3dcb439

Knex.js - A SQL Query Builder for Javascript - home page

https://knexjs.org/

Knex.js (pronounced /kəˈnɛks/) is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. ...

simplql

https://simplql.com/#about

How to Create Database Indexes: Databases for Developers: Performance 12min

https://www.youtube.com/watch?v=7wLFr7ZnKPU&feature=emb_logo

Indexes are one of the most common performance tools available. But how do you create one? And how does it help the database find your data faster?

Watch this video to learn how to create an index a...

How to Create and Use Indexes in Oracle Database

https://blogs.oracle.com/sql/how-to-create-and-use-indexes-in-oracle-database

Indexes. They're one of the most powerful and misunderstood aspects of SQL performance. In this post we'll look at the purpose of an index, how to create and choose choose your index type. Then finish...

ElephantSQL - PostgreSQL as a Service

https://www.elephantsql.com/

ElephantSQL - PostgreSQL as a Service. The most advanced open-source database, hosted in the cloud.

8 New SQL Tools That Will Change How You Work in 2020 - DEV Community 👩‍💻👨‍💻

https://dev.to/realtrevorfaux/8-new-sql-tools-that-will-change-how-you-work-in-2020-n63

How does database indexing work?

https://stackoverflow.com/questions/1108/how-does-database-indexing-work

Why is it needed?

When data is stored on disk-based storage devices, it is stored as blocks of data. These blocks are accessed in their entirety, making them the atomic disk access operation. Disk bl...

Complete Guide: Inheritance strategies with JPA and Hibernate

https://thoughts-on-java.org/complete-guide-inheritance-strategies-jpa-hibernate/#comments

Hibernate and JPA support 4 inheritance strategies which map the entities to different table models. But which one is the best for your use case?

steffengy/tiberius

https://github.com/steffengy/tiberius

AgilData/mysql-proxy-rs

https://github.com/AgilData/mysql-proxy-rs

A MySQL Proxy

jgallagher/rusqlite

https://github.com/jgallagher/rusqlite

Sqlite3 bindings

diesel-rs/diesel

https://github.com/diesel-rs/diesel

an ORM and Query builder for Rust Build Status

ivanceras/rustorm

https://github.com/ivanceras/rustorm

an ORM for Rust Build Status

GraphpostgresQL

https://github.com/solidsnack/GraphpostgresQL

GraphQL for Postgres.

sql-to-graphql

https://github.com/rexxars/sql-to-graphql

Generate a GraphQL API based on your SQL database structure.

PostGraphile

https://github.com/graphile/postgraphile

Lightning-fast GraphQL APIs for PostgreSQL: highly customisable; extensible via plugins; realtime.

Hasura

https://github.com/hasura/graphql-engine

Hasura gives Instant Realtime GraphQL APIs over PostgreSQL. Works with an existing database too.

Online SQLite browser

https://extendsclass.com/sqlite-browser.html

SQLite Browser is a online SQL interpreter for SQLite database. Open and execute queries from a SQLite file. Neither download nor installation.

Visual Representation of SQL Joins - CodeProject

https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

I'm a pretty visual person. Things seem to make more sense as a picture. I looked all over the Internet for a good graphical representation of SQL JOINs, but I couldn't find any to my liking. Some had...

  • :calendar: published on: 2009-02-03
  • tags: sql

Sqlectron - One single DB client for any relational DB

https://sqlectron.github.io/

UNMAINTAINED - SEE BELOW. A simple and lightweight SQL client desktop with cross database and platform support.

Knex.js - A SQL Query Builder for Javascript

http://knexjs.org/

Knex.js is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. It features both tradit...

SQL SELECT DISTINCT | COUNT | ROWS | On one columns | Examples

http://www.dofactory.com/sql/select-distinct

SQL SELECT DISTINCT with COUNT on ROWS or on one columns

  • SELECT DISTINCT returns only distinct (different) values.
  • SELECT DISTINCT eliminates duplicate records from the results.
  • DISTINCT can be...
  • tags: sql

Java, SQL and jOOQ. – Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.

https://blog.jooq.org/

Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.

Συστήματα Βάσεων Δεδομένων - Θεωρία και πρακτική εφαρμογή

http://studentguru.gr/cfs-file/__key/telligent-evolution-components-attachments/13-1200-00-00-00-13-...

(PDF)

SQL - podstawy (na stronie)

http://andrzejklusiewicz.blogspot.com/2010/11/kurs-oracle-sql.html

PL/SQL - podstawy (na stronie)

http://andrzejklusiewicz.blogspot.com/2010/11/kurs-oracle-plsql.html

SQLプログラミング作法

http://www.geocities.jp/mickindex/database/db_manner.html

ミック

SQLアタマ養成講座

http://www.geocities.jp/mickindex/database/WDP/WDP_44.pdf

ミック WEB+DB Press Vol.44 (2008) p.47-72 (PDF)

SQL

http://www.techscore.com/tech/sql/

シナジーマーケティング株式会社

Tutorial de SQL

http://www.desarrolloweb.com/manuales/9/

El lenguaje SQL

http://ocw.uoc.edu/computer-science-technology-and-multimedia/bases-de-datos/bases-de-datos/P06_M210...

(PDF)

Manual de gestión de base de datos

http://www.jorgesanchez.net/bd/gbd2012.pdf

(PDF)

Cours complet pour apprendre les différents types de bases de données et le langage SQL

https://sgbd.developpez.com/tutoriels/cours-complet-bdd-sql/

Jacques Le Maitre

Use The Index, Luke!: A Guide To SQL Database Performance

http://use-the-index-luke.com

SQL For Web Nerds

http://philip.greenspun.com/sql/

Developing Time-Oriented Database Applications in SQL

http://www.cs.arizona.edu/people/rts/publications.html

A Primer on SQL, Second Edition

https://leanpub.com/aprimeronsql

[Intro to SQL: Querying and managing data |

Khan Academy](https://www.khanacademy.org/computing/computer-programming/sql) https://www.khanacademy.org/computing/computer-programming/sql

Learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and o...