VirtualTam's bookmarks

21. Vitess | A database clustering system for horizontal scaling of MySQL 2018-12-12

    tags: database, database/mysql, distributed-system/cluster, google, programming/sql, shard

    [ permalink ]

    • https://github.com/vitessio/vitess
    • https://www.reddit.com/r/programming/comments/qakq4/google_releases_vitess_used_in_the_core_of/
22. vim-sql-workbench: SQL database access for Vim 2018-11-09

    tags: database, editor/vim, programming/sql, query

    [ permalink ]

    • https://www.vim.org/scripts/script.php?script_id=5081
    • https://github.com/cosminadrianpopescu/vim-sql-workbench/tree/master/resources/screenshots
    • http://www.sql-workbench.eu/
23. mysql - What column type/length should I use for storing a Bcrypt hashed password in a Database? - Stack Overflow 2018-10-21

    tags: cryptography/hash, database, database/mariadb, database/mysql, programming/sql, security/password

    [ permalink ]

    • https://stackoverflow.com/questions/51008351/bcrypt-hashedsecret-too-short-to-be-a-bcrypted-password
    • https://stackoverflow.com/questions/247304/what-data-type-to-use-for-hashed-password-field-and-what-length
24. python-sqlparse - a non-validating SQL parser module for Python 2018-10-21

    tags: database, database/mariadb, database/mysql, database/postgresql, database/sqlite, parser, programming/python, programming/sql

    [ permalink ]

    • https://github.com/andialbrecht/sqlparse
25. ClickHouse — open source distributed column-oriented DBMS 2018-09-24

    tags: database, distributed, performance, programming/sql

    [ permalink ]

    • https://github.com/yandex/ClickHouse
    • https://www.percona.com/blog/2017/02/13/clickhouse-new-opensource-columnar-database/
    • https://www.percona.com/blog/2017/03/17/column-store-database-benchmarks-mariadb-columnstore-vs-clickhouse-vs-apache-spark/
    • https://www.reddit.com/r/programming/comments/4o7dhc/clickhouse_highperformance_opensource_distributed/
    • https://github.com/roistat/go-clickhouse
    • https://blog.sentry.io/2019/05/16/introducing-snuba-sentrys-new-search-infrastructure
26. A Lesson In Low-Defect Software - A Journey From A Quick Hack To A High-Reliability Database Engine 2018-04-27

    tags: code, database, database/sqlite, programming/sql, programming/testing

    [ permalink ]
27. Django, Docker and MySQL 2017-11-29

    tags: database, database/migration, database/mysql, framework/django, linux/container/docker, programming/python, programming/sql

    [ permalink ]

    Django ORM:

    • https://docs.djangoproject.com/en/1.11/ref/databases/#mysql-notes
    • https://stackoverflow.com/questions/34777755/how-to-config-django-using-pymysql-as-driver
    • https://stackoverflow.com/questions/19189813/setting-django-up-to-use-mysql

    MySQL / MariaDB / Percona connectors:

    • https://stackoverflow.com/questions/4960048/python-3-and-mysql
    • https://github.com/PyMySQL/PyMySQL
    • https://pypi.python.org/pypi/mysql-connector-python

    Docker images:

    • https://store.docker.com/images/mariadb
    • https://store.docker.com/images/mysql
    • https://store.docker.com/images/percona

    Compose and Django ORM database migrations:

    • https://docs.docker.com/compose/django/
    • https://stackoverflow.com/questions/33992867/how-do-you-perform-django-database-migrations-when-using-docker-compose
    • https://www.stavros.io/posts/how-deploy-django-docker/
    • https://docs.docker.com/compose/startup-order/
28. PostgreSQL: Documentation: 9.6: Schemas 2017-08-20

    tags: database, database/postgresql, framework/flask, programming/python, programming/sql, schema, sqlalchemy

    [ permalink ]

    • https://wiki.postgresql.org/wiki/Database_Schema_Recommendations_for_an_Application
    • https://stackoverflow.com/questions/9298296/sqlalchemy-support-of-postgres-schemas
    • https://github.com/bernardopires/django-tenant-schemas
29. How I Structure My Flask Applications — mattupstate.com 2017-06-23

    tags: framework/flask, programming/python, programming/sql, template, web

    [ permalink ]

    • https://github.com/mattupstate/overholt
30. Django vs Flask — git-pull.com 2017-06-23

    tags: comparison, database, framework, framework/django, framework/flask, programming/python, programming/sql, web

    [ permalink ]
31. Build a CRUD Web App With Python and Flask ― Scotch 2017-05-23

    tags: bootstrap, database, framework/flask, programming/css, programming/html, programming/python, programming/sql, security/authentication, tutorial, web, wsgi

    [ permalink ]

    Part 1 - https://scotch.io/tutorials/build-a-crud-web-app-with-python-and-flask-part-one

    • https://github.com/mbithenzomo/project-dream-team-one
    • http://flask.pocoo.org/docs/0.12/config/
    • http://flask.pocoo.org/docs/0.12/patterns/appfactories/
    • http://flask.pocoo.org/docs/0.12/blueprints/
    • http://flask-sqlalchemy.pocoo.org/2.2/config/

    Part 2 - https://scotch.io/tutorials/build-a-crud-web-app-with-python-and-flask-part-two

    • https://github.com/mbithenzomo/project-dream-team-two

    Part 3 - https://scotch.io/tutorials/build-a-crud-web-app-with-python-and-flask-part-three

    • https://github.com/mbithenzomo/project-dream-team-three
32. Testing Flask applications with pytest 2017-05-23

    tags: framework/flask, network/http, programming/json, programming/python, programming/python/pytest, programming/sql, programming/testing

    [ permalink ]

    • http://alexmic.net/flask-sqlalchemy-pytest/ // https://gist.github.com/alexmic/7857543
    • http://piotr.banaszkiewicz.org/blog/2014/02/22/how-to-bite-flask-sqlalchemy-and-pytest-all-at-once/
    • http://flask.pocoo.org/docs/0.12/testing/
    • https://docs.pytest.org/en/latest/
    • https://pytest-flask.readthedocs.io/en/latest/
    • https://stackoverflow.com/questions/28836893/how-to-send-requests-with-jsons-in-unit-tests
33. JSON data with SQLAlchemy and Flask 2017-05-19

    tags: data, database, framework/flask, programming/json, programming/python, programming/sql

    [ permalink ]

    • https://stackoverflow.com/questions/27682685/how-to-store-and-access-json-array-data-in-postgresql-with-sqlalchemy
    • https://pypi.python.org/pypi/SQLAlchemy-JSONField/0.6.3
    • http://variable-scope.com/posts/creating-a-json-column-type-for-sqlalchemy
    • https://pypi.python.org/pypi/flask_jsontools
34. python - Pylint can't find SQLAlchemy query member - Stack Overflow 2017-05-19

    tags: class, framework/flask, model, programming/python, programming/python/pylint, programming/sql, static-analysis/lint

    [ permalink ]
35. How do I declare a base model class in Flask-SQLAlchemy? - Stack Overflow 2017-05-19

    tags: abstract, database, framework/flask, mixin, model, programming/python, programming/sql

    [ permalink ]

    • https://stackoverflow.com/questions/25055877/flask-sqlalchemy-abstract-base-model
    • http://docs.sqlalchemy.org/en/latest/orm/extensions/declarative/api.html#abstract
    • http://docs.sqlalchemy.org/en/latest/orm/extensions/declarative/mixins.html#declarative-mixins
36. Flask-Base | Documentation 2017-05-15

    tags: database, example, framework/flask, programming/python, programming/sql, template

    [ permalink ]

    • https://github.com/hack4impact/flask-base
    • via https://www.reddit.com/r/Python/comments/5pdf54/a_dead_simple_flask_boilerplate_app_with/
    • https://medium.freecodecamp.com/how-we-got-a-2-year-old-repo-trending-on-github-in-just-48-hours-12151039d78b
37. 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/
38. 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/
39. 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, diff, programming/sql, schema

    [ permalink ]
40. 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