Skip to content

SQLalchemy Tutorial

Check out dentropys-sqlalchemy-tutorial

Questions

  • Keywords
  • Datatypes
  • Restrictions
  • Variable (Procedural SQL)
  • Cursors
  • Ref
  • Trigger

Cursors

To Learn

  • I need to learn how to back up a SQL Database
  • I need to learn how to manage permissions in a SQL database
  • I need to learn how to do database migrations
  • I need to learn how to recover a SQL database form a backup
  • I need to learn how to shard a SQL database
  • I need to learn how to cluser a SQL database

Search String in Column

Select from_user, txt_body 
from Messages 
where txt_body 
  like '%id %' AND msg_type == "text"

sql - How to search for a substring in SQLite? - Stack Overflow

TODO

  • Skipping Explit Forin Key's cause SQLite
  • In SQL Alchemy we want Forein Key's
  • I don't know how to use forein keys really

Sources