| 214 | | == SQL Database Programming == |
| 215 | | === Design Principles === |
| 216 | | * http://it.toolbox.com/blogs/database-soup/wrecking-your-database-33298 |
| 217 | | * https://www.percona.com/blog/2009/03/01/kiss-kiss-kiss/ |
| 218 | | * Book: https://pragprog.com/book/bksqla/sql-antipatterns |
| 219 | | * //SQL antipatterns : avoiding the pitfalls of database programming// [http://www.worldcat.org/title/sql-antipatterns-avoiding-the-pitfalls-of-database-programming/oclc/886727368 WorldCat][https://pragprog.com/book/bksqla/sql-antipatterns The Pragmatic Bookshelf] |
| 220 | | * Review [http://shop.oreilly.com/product/9781934356555.do O'Reilly] |
| 221 | | * //SQL design patterns : the expert guide to SQL programming// [http://www.worldcat.org/title/sql-design-patterns-the-expert-guide-to-sql-programming/oclc/86074635 WorldCat] [http://www.rampant-books.com/book_0601_sql_coding_styles.htm Rampant] |
| 222 | | === Tree or Hierarchical Data === |
| 223 | | * nested-set, closure-table and materialized-path. |
| 224 | | * //Tree_(data_structure)// [https://en.wikipedia.org/wiki/Tree_(data_structure) Wikipedia] |
| 225 | | * Joe Celkos: //Trees and Hierarchies in SQL for Smarties// [http://www.worldcat.org/title/joe-celkos-trees-and-hierarchies-in-sql-for-smarties/oclc/795963625 WorldCat] [http://aleph.unisg.ch/hsgscan/hm00391779.pdf Table of Content (pdf)] |
| 226 | | * //SQL - How to store and navigate hierarchies?// [https://stackoverflow.com/questions/38801/sql-how-to-store-and-navigate-hierarchies stackoverflow] |
| 227 | | * //How to represent a data tree in SQL?// [https://stackoverflow.com/questions/2175882/how-to-represent-a-data-tree-in-sql stackoverflow] |
| 228 | | * //Models for hierarchical data// [http://www.slideshare.net/billkarwin/models-for-hierarchical-data SlideShare] |
| 229 | | * //How to represent a tree structure numerically in SQL Server// [https://yellowpencil.com/blog/how-to-represent-a-tree-structure-numerically-in-sql-server/ yellowpencil] (short HOWTO) |
| 230 | | * //Closure Table – Store Hierarchical Data Seamlessly | PostgreSQL// [http://technobytz.com/closure_table_store_hierarchical_data.html technobytz] (short HOWTO) |
| 231 | | * //What is the most efficient/elegant way to parse a flat table into a tree?// [https://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree stackoverflow] |
| 232 | | * //Storing hierarchical data: Materialized Path// [https://bojanz.wordpress.com/2014/04/25/storing-hierarchical-data-materialized-path/ Blog] |
| 233 | | === Blobs for documents === |
| 234 | | * FAQ: http://stackoverflow.com/questions/211895/storing-documents-as-blobs-in-a-database-any-disadvantages |
| 235 | | === Serialized Objects === |
| 236 | | * https://www.percona.com/blog/2010/01/21/when-should-you-store-serialized-objects-in-the-database |
| 237 | | == SQL == |
| 238 | | * https://en.wikibooks.org/wiki/Structured_Query_Language/Introduction_to_SQL |
| 239 | | * https://en.wikipedia.org/wiki/SQL |
| 240 | | ==== Views ==== |
| 241 | | * http://www.postgresql.org/docs/current/static/sql-createview.html |
| 242 | | * http://www.doctrine-project.org/2009/06/19/using-views-with-doctrine.html (is it always valid?) |
| 243 | | * http://www.postgresql.org/docs/current/static/rules-materializedviews.html |
| 244 | | ==== sql procedural language ==== |
| 245 | | * https://en.wikipedia.org/wiki/SQL#Procedural_extensions |
| 246 | | * https://en.wikipedia.org/wiki/SQL/PSM |
| 247 | | * https://en.wikipedia.org/wiki/Stored_procedure |
| 248 | | ==== Supported features ==== |
| 249 | | ===== Data Types ===== |
| 250 | | ====== json ====== |
| 251 | | * SQLite https://www.sqlite.org/json1.html |
| 252 | | ====== XML ====== |
| 253 | | * Seems not yet to be in Firebird |
| 254 | | === Embedded Database Programming === |
| 255 | | * https://en.wikipedia.org/wiki/Embedded_database |
| 256 | | * QDBM, BDB, http://php.net/manual/en/function.dba-handlers.php |
| 257 | | * [DebianPackage:php-tokyo-tyrant] |
| 258 | | * [DebianPackage:php7.0-interbase] (php driver does not include embeded version of interbase) [DebianPackage:libfbembed2.5] |
| 259 | | * https://wiki.documentfoundation.org/Development/Base/FirebirdSQL |
| 260 | | * https://en.wikipedia.org/wiki/InterBase |
| 261 | | * https://en.wikipedia.org/wiki/Firebird_%28database_server%29 |
| 262 | | * http://www.haildb.com/ |
| 263 | | * [DebianPackage:php5-midgard2] |
| 264 | | === sqlite === |
| 265 | | * [https://www.sqlite.org/omitted.html SQL Features That SQLite Does Not Implement] |
| 266 | | * https://www.sqlite.org/json1.html |
| 267 | | * https://www.sqlite.org/fts5.html |
| 268 | | * [https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=816463 Please enable FTS5 support] https://tracker.debian.org/media/packages/s/sqlite3/rules-3.11.0-3 |
| 269 | | === HSQLDB (Hyper SQL Database) === |
| 270 | | * https://en.wikipedia.org/wiki/HSQLDB |
| 271 | | === Postgres === |
| 272 | | * https://wiki.debian.org/PostgreSql |
| 273 | | * http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf |
| 274 | | * http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.133.8073&rep=rep1&type=pdf |
| 275 | | * https://dl.acm.org/citation.cfm?id=2834495 |
| 276 | | ==== Performance ==== |
| 277 | | * http://fr.slideshare.net/pgconf/five-steps-perform2009 |
| 278 | | ==== Timing ==== |
| 279 | | * [http://www.postgresql.org/message-id/4D9EABDD.1060102@limsi.fr Re: What does \timing measure?] |
| 280 | | * http://www.postgresql.org/docs/9.4/static/runtime-config-statistics.html |
| 281 | | * http://stackoverflow.com/questions/17653884/postgres-query-execution-time |
| 282 | | * http://stackoverflow.com/questions/9063402/get-execution-time-of-postgresql-query |
| 283 | | ==== Procedural Language ==== |
| 284 | | * https://wiki.postgresql.org/wiki/PL_Matrix |
| 285 | | * PL/pgSQL |
| 286 | | * Included in postgresql~ basic Debian Package |
| 287 | | * http://www.postgresql.org/docs/9.3/static/plpgsql.html |
| 288 | | * https://en.wikipedia.org/wiki/PL/pgSQL |
| 289 | | * http://postgres.cz/wiki/PL/pgSQL_(en) |
| 290 | | * [DebianPackage:postgresql-plpython-9.4] more stable and more popular that PL/Lua |
| 291 | | * [DebianPackage:postgresql-plpython3-9.4] |
| 292 | | * [DebianPackage:postgresql-9.4-pllua] https://github.com/pllua/pllua http://wiki.alpinelinux.org/wiki/Pllua |
| 293 | | * [DebianPackage:postgresql-pltcl-9.4] |
| 294 | | * [DebianPackage:postgresql-9.4-plsh] |
| 295 | | ==== General information and Feature Lists ==== |
| 296 | | * [https://www.safaribooksonline.com/library/view/postgresql-up-and/9781449373184/ch01.html PostgreSQL: Up and Running] |
| 297 | | * [https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases Advertisement by a provider] |
| 298 | | ===== Release Notes and Documentation ===== |
| 299 | | * [http://www.postgresql.org/about/news/1415/ PostgreSQL 9.2 released] |
| 300 | | === MySQL === |
| 301 | | * https://en.wikipedia.org/wiki/MySQL |
| 302 | | ==== Stored Procedure ==== |
| 303 | | * MySQL stored procedure programming |
| 304 | | * http://www.worldcat.org/oclc/70161318 |
| 305 | | * http://www.worldcat.org/oclc/850445083 |
| 306 | | * MySQL Cookbook |
| 307 | | * http://www.worldcat.org/oclc/76905222 |
| 308 | | === Firebird === |
| 309 | | * https://wiki.documentfoundation.org/Development/Base/FirebirdSQL |
| 310 | | * http://stackoverflow.com/questions/1635273/postgres-vs-firebird |
