VirtualTam's bookmarks

1. Audit a MySQL or MariaDB database 2019-02-19

   tags: database, database/mariadb, database/mysql, observability, performance, security/audit

   [ permalink ]

   • https://vincent.composieux.fr/article/auditer-une-base-de-donnees-mysql-ou-mariadb
2. 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/
3. 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
4. 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
5. 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
6. MySQL configuration: when to use hyphen and when to use underscore - Stack Overflow 2018-08-29

   tags: configuration, database, database/mariadb, database/mysql

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