Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
devwiki:sql [2016/10/20 01:17]
127.0.0.1 external edit
devwiki:sql [2019/06/28 02:40] (current)
ying [Field Type]
Line 9: Line 9:
   * sqlite tool in firefox   * sqlite tool in firefox
     * https://​addons.mozilla.org/​en-US/​firefox/​addon/​sqlite-manager/​     * https://​addons.mozilla.org/​en-US/​firefox/​addon/​sqlite-manager/​
 +
 +  * sqlite desktop tool
 +    * DB Browser for SQLite: https://​sqlitebrowser.org/​
 ====== database algebra ====== ====== database algebra ======
  
Line 25: Line 28:
   * Unique for indexing and searching   * Unique for indexing and searching
  
 +  * BLOB type: a binary data type, "​binary large object"​
 +    * read and write photo file in DB: http://​www.mysqltutorial.org/​python-mysql-blob/​