VirtualTam's bookmarks

21. Bye bye Mongo, Hello Postgres | Digital blog | Info | The Guardian 2018-12-21

    tags: cloud, cloud/aws, database, database/mongodb, database/postgresql, distributed-system/cluster, performance

    [ permalink ]

    • https://github.com/guardian/machine-images
    • https://www.theguardian.com/uk-news/live/2015/jul/01/heatwave-live-britain-hottest-day-2015
22. DBCLI - Commandline Database Clients with Autocompletion and Syntax Highlighting 2018-12-05

    tags: command-line, database, database/mariadb, database/mysql, database/postgresql, database/sqlite, programming/python, terminal

    [ permalink ]

    • https://github.com/dbcli/litecli
    • https://www.mycli.net/
    • https://www.pgcli.com/
    • https://web-techno.net/mysql-command-line-tool-mycli/
23. 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
24. pgcli - a command line interface for Postgres with auto-completion and syntax highlighting 2018-07-23

    tags: command-line, database, database/postgresql, programming/python

    [ permalink ]

    • https://github.com/dbcli/pgcli
25. Joseph Leingang - Temporal Data Structures with SQLAlchemy and Postgres - PyCon 2017 2018-03-01

    tags: database, database/postgresql, programming/python, sqlalchemy

    [ permalink ]
26. 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
27. 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
28. 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/
29. /r/linux - Gitlab is down: notes on the incident (and why you should always check backups) 2017-02-02

    tags: database, database/postgresql, failure, linux, recovery, replication, source-code-management/git, source-code-management/gitlab, sysadmin, tale

    [ permalink ]

    https://www.theregister.co.uk/2017/02/02/gitlabcom_has_found_and_restored_from_an_accidental_backup/ https://www.reddit.com/r/linux/comments/5rmhwg/gitlabcom_luckily_found_lost_data_on_a_staging/

30. 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 ]
31. Setting up Django with Nginx, Gunicorn, virtualenv, supervisor and PostgreSQL - Michał Karzyński 2014-11-13

    tags: database/postgresql, development, framework/django, network/proxy, programming/python, server, sysadmin, web

    [ permalink ]
32. Create Function... ERROR: language 'plpgsql' does not exist - PostgreSQL Database 2014-06-08

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

    [ permalink ]
33. Lisp Downloads -=- Eric Marsden 2013-08-18

    tags: database/postgresql, development, editor/emacs, htcpcp, programming/emacs-lisp, programming/lisp, web

    [ permalink ]

    Cool Lisp modes, featuring coffee.el (HTCPCP) and some server (httpd, postgres) utils