User Tools
database_views
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
database_views [2019/03/24 14:40] steve [Database Views] |
database_views [2019/03/24 15:35] steve [SQLite] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Database Views ====== | ====== Database Views ====== | ||
| - | On all the SQL database schemas, the data is [[https://en.wikipedia.org/wiki/Database_normalization|normalized]]. However, I realize most people don't want to write a lot of JOINS just to get to what they want, and so there is ''scriptures'' VIEW that runs the query for you to return a non-normalized result set. | + | On all the SQL database schemas, the data is [[https://en.wikipedia.org/wiki/Database_normalization|normalized]]. However, I realize most people don't want to write a lot of JOINs just to get to what they want, and so there is ''scriptures'' VIEW that runs the query for you to return a non-normalized result set. |
| Each database is different, but for the sake of simplicity, here's the schema for some: | Each database is different, but for the sake of simplicity, here's the schema for some: | ||
| - | ==== SQLite ==== | + | ===== SQLite ===== |
| <code> | <code> | ||
database_views.txt ยท Last modified: 2019/03/24 16:52 by steve
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
