Hacker News new | ask | show | jobs
by pizza234 807 days ago
The compatibility (and functionality in general) is severely limited, not usable in production:

> No transaction support. Statements like START TRANSACTION, ROLLBACK, and COMMIT are no-ops.

> Non-performant index implementation. Indexed lookups and joins perform full table scans on the underlying tables.

I actually wonder if they support triggers, stored procedures etc.
2 comments
zachmu 807 days ago
Yes, triggers and stored procedures are supported. Concurrency is the only real limitation in terms of functionality.

The bundled in-memory database implementation is mostly for use in testing, for people who run against mysql in prod and want a fast compatible go library to test against.

For a production-ready database that uses this engine, see Dolt:

https://github.com/dolthub/dolt

link
zgk7iqea 807 days ago
Only for the in-memory implementation. It is also specifically stated that you shouldn’t use the in-memory stub in production
link