AliSQL: Alibaba's open-source MySQL with vector and DuckDB engines(github.com)
88 pointsby baotiao3 hours ago5 comments
  • jimmyl028 minutes ago
    HTAP is here! It seems like these hybrid databases are slowly gaining adoption which is really cool to see.

    The most interesting part of this is the improvements to transaction handling that it seems they've made in https://github.com/alibaba/AliSQL/blob/master/wiki/duckdb/du... (its also a good high level breakdown of MySQL internals too). Ensuring that the sync between the primary tables and the analytical ones are fast and most importantly, transactional, is awesome to see.

  • Keyframe19 minutes ago
    On a drive-by-glance it looks like if you had a tighter integrated version of PSQL FDW for DuckDB and Vector Storage - meets Vespa. I find it interesting they went with extending MySQL instead of FDW route on PSQL?
  • linuxhansl2 hours ago
    Curious how it stacks up to pg_duckdb. (pg_duckdb seems pretty clean, due to Postres' powerful extension mechanisms)
  • dzonga2 hours ago
    having an embedded column database for analytics in your traditional db is a massive win for productivity + operations simplicity.

    at the moment I use PG + Tiger Data - couldn't find a mysql equivalent

    so this as one.

    • mhitza34 minutes ago
      Mariadb has a columnar engine already (though I did not use it myself) https://mariadb.com/docs/analytics/mariadb-columnstore/colum... and is mostly mysql compatible.

      For about a year releases include a vector storage type, so it will be interesting to see it compared in performance with what Alibaba did.

      Just wanted to plug that out. Given how often Postgres is plugged on HN, I think people ignore how versatile mariadb is.

    • tempest_2 hours ago
      Can tiger data be used just as a simple column store?

      All I want is effectively what clickhouse does in PG. I have a single table that I need fast counts on and clickhouse can do the counts fast but I have to go through the entire sync/replication to do that.

      A quick scan of TimeSeries always seemed like it was really only best setup for that and to use it another way would be a bit of a struggle.

    • rjh29an hour ago
      Clickhouse supports MySQL protocol natively, and can also wrap/import MySQL tables. Okay so you need two connections but it works pretty well.
    • travem2 hours ago
      One option is TiDB. It has support for columnar data alongside row based data. However, it is MySQL compatible, but not based on MySQL code so not quite what you asked for.
    • awesome_dude42 minutes ago
      MariaDB has supported columnar tables for a bit https://mariadb.com/resources/blog/see-columnar-storage-for-...
  • milesward3 hours ago
    [flagged]
    • akie2 hours ago
      In almost no situation is laughing at what someone says appropriate, also not here.
    • 2 hours ago
      undefined