Bookmarks tagged [sql]
https://www.youtube.com/watch?v=ZS_kXvOeQ5Y
SQL or NoSQL? MySQL vs MongoDB? Which database is better? Which one should you use?
https://tomharrisonjr.com/uuid-or-guid-as-primary-keys-be-careful-7b2aa3dcb439
- Reasons UUIDs are Good
- Reasons UUIDs May Not be Good
- 📆 published on: 2017-02-13
- tags: sql, database, database-design, primary-key
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. ...
- tags: sql, node.js, query-builder, mysql, postgresql
source code
- tags: sql
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...
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. The most advanced open-source database, hosted in the cloud.
https://dev.to/realtrevorfaux/8-new-sql-tools-that-will-change-how-you-work-in-2020-n63
- tags: sql
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...
- 📆 published on: 2008-08-04
- tags: sql, database, performance, indexing, database-indexes
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?
- tags: java, jpa, hibernate, inheritance, sql
https://github.com/steffengy/tiberius
- tags: rust, database, sql, sql-server
- source code
https://github.com/AgilData/mysql-proxy-rs
A MySQL Proxy
- tags: rust, database, sql, mysql
- source code
https://github.com/jgallagher/rusqlite
Sqlite3 bindings
- tags: rust, database, sql, sqlite
- source code
https://github.com/diesel-rs/diesel
an ORM and Query builder for Rust
- tags: rust, database, sql, orm
- source code
https://github.com/ivanceras/rustorm
an ORM for Rust
- tags: rust, database, sql, orm
- source code
https://github.com/solidsnack/GraphpostgresQL
GraphQL for Postgres.
- tags: graphql, sql, libraries
- source code
https://github.com/rexxars/sql-to-graphql
Generate a GraphQL API based on your SQL database structure.
- tags: graphql, sql, libraries
- source code
https://github.com/graphile/postgraphile
Lightning-fast GraphQL APIs for PostgreSQL: highly customisable; extensible via plugins; realtime.
- tags: graphql, sql, libraries
- source code
https://github.com/hasura/graphql-engine
Hasura gives Instant Realtime GraphQL APIs over PostgreSQL. Works with an existing database too.
- tags: graphql, sql, libraries
- source code
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.
- 📆 published on: 2019-03-06
- tags: online-tools, sql
- source code
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...
- 📆 published on: 2009-02-03
- tags: sql
UNMAINTAINED - SEE BELOW. A simple and lightweight SQL client desktop with cross database and platform support.
- tags: sql, tools, mysql
- source code
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...
- tags: orm, sql, node.js, postgresql, mysql
- source code
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.
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)
http://andrzejklusiewicz.blogspot.com/2010/11/kurs-oracle-sql.html
http://andrzejklusiewicz.blogspot.com/2010/11/kurs-oracle-plsql.html
http://www.geocities.jp/mickindex/database/db_manner.html
ミック
http://www.geocities.jp/mickindex/database/WDP/WDP_44.pdf
ミック WEB+DB Press Vol.44 (2008) p.47-72 (PDF)
http://www.techscore.com/tech/sql/
シナジーマーケティング株式会社
http://www.desarrolloweb.com/manuales/9/
http://ocw.uoc.edu/computer-science-technology-and-multimedia/bases-de-datos/bases-de-datos/P06_M210...
(PDF)
http://www.jorgesanchez.net/bd/gbd2012.pdf
(PDF)
https://sgbd.developpez.com/tutoriels/cours-complet-bdd-sql/
Jacques Le Maitre
- tags: free-programming-books, sql
http://philip.greenspun.com/sql/
- tags: free-programming-books, sql
http://www.cs.arizona.edu/people/rts/publications.html
- tags: free-programming-books, sql
https://leanpub.com/aprimeronsql
- tags: free-programming-books, sql
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...
- tags: sql