VirtualTam's bookmarks

41. Build An App Using Flask, SQLAlchemy and PostgreSQL 9.2 2017-05-15

    tags: database/postgresql, framework/flask, linux/container, openshift, programming/python, programming/sql, web

    [ permalink ]

    • https://blog.openshift.com/use-flask-login-to-add-user-authentication-to-your-python-application/
    • https://blog.openshift.com/announcing-a-new-book-getting-started-with-openshift-a-guide-for-impatient-beginners/
42. SQLAlchemy - The Database Toolkit for Python 2017-05-15

    tags: database, object, programming/python, programming/sql

    [ permalink ]

    • http://alembic.zzzcomputing.com/en/latest/
    • http://www.chesnok.com/daily/2013/07/02/a-practical-guide-to-using-alembic/
43. joncrlsn/pgdiff: Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database. 2016-12-12

    tags: database, database/postgresql, programming/sql, schema, text/diff

    [ permalink ]
44. SQLite Memo 2015-03-14

    tags: data, database, database/sqlite, programming/sql

    [ permalink ]

    Common ops & clauses:

    • CREATE TABLE - https://www.sqlite.org/lang_createtable.html
    • ALTER TABLE - https://www.sqlite.org/lang_altertable.html
    • UPDATE - https://www.sqlite.org/lang_update.html
45. Create Function... ERROR: language 'plpgsql' does not exist - PostgreSQL Database 2014-06-08

    tags: database, database/postgresql, development, programming/sql, psql, web

    [ permalink ]