MariaDB VS Sqitch

MariaDB Reviews

Sqitch Reviews

MariaDB mentions (33)

• MariaDB 10.9 on OpenBSD 7.3: Install

  WARNING: The host '(...)' could not be looked up with /usr/local/bin/resolveip. This probably means that your libc libraries are not 100 % compatible With this binary MariaDB version. The MariaDB daemon, mysqld, should work Normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames When specifying MariaDB privileges ! Installing... - Source: dev.to / 8 months ago

• Unable to start with "pam_use_cleartext_plugin" enabled

  i'm running MariaDB 10.6 from mariadb.org Repos in Debian 11. For authentication I'm using PAM and Active Directory. Source: 11 months ago

• MariaDB installation error with Docker Compose

  1-db-1 | The latest information about MariaDB is available at https://mariadb.org/. Source: 11 months ago

• How to install MariaDB 10.10.3 on Rocky 9.1

  Cat /etc/redhat-release Rocky Linux release 9.1 (Blue Onyx) Yum info mariadb-server Last metadata expiration check: 1:42:14 ago on Sun 09 Apr 2023 03:56:00 PM IST. Installed Packages Name : mariadb-server Epoch : 3 Version : 10.5.16 Release : 2.el9_0 Architecture : x86_64 Size : 62 M Source : mariadb-10.5.16-2.el9_0.src.rpm Repository : @System From repo :... Source: about 1 year ago

• Running MS SQL or SQL Express on DS723+

  If it will take MySQL or MariaDB as a backend then its a lot simpler (and cheaper) as standard Docker containers for these are available and other folk use these on Synology kit way more. Source: about 1 year ago

Sqitch mentions (17)

• Ask HN: What tool(s) do you use to code review and deploy SQL scripts?

  We use https://sqitch.org/ and we’re fairly happy with it. Sqitch manages the files to deploy which are applied fits to a local database. We use GitHub actions for deployment and database migrations are just one step of the pipeline. The step invokes sqitch deploy which runs all the pending migration files. Then, all the approval process is standard for the environment. We require approvals in pull requests... - Source: Hacker News / 20 days ago

• PostgREST: Providing HTML Content Using Htmx

  I'm experimenting with it right now using Squitch [1] to make maintenance easier. It still feels like a hack and I also still have my doubts about the viability of this for real-world use. It's fun though and I'm learning about all kinds of advanced Postgres features. [1] https://sqitch.org/. - Source: Hacker News / 5 months ago

• Announcing codd - a tool to apply postgres SQL migrations

  How does it compare with other SQL-based migration tools like Sqitch? Source: about 1 year ago

• Ask HN: How do you test SQL?

  Yup, same. Last time I set this up I used Sqitch¹ for migrations, which encourages you to write tests for each migration; caught a lot of bugs early that way, all in a local-first dev environment. Worked especially well for Postgres since plpgsql makes it easy to write tests more imperatively. ¹: https://sqitch.org/. - Source: Hacker News / over 1 year ago

• Conceptually how do you handle deploys of SQL related things (table definition, scripts, stored procs etc) in a CI/CD way?

  Sqitch. DB migrations for multiple data stores without a proprietary syntax for DB updates. Git-aware. Integrated unit testing. Https://sqitch.org/ Https://youtu.be/wF4PEe8HD7k. Source: over 1 year ago