3 ms·
The compatibility (and functionality in general) is severely limited, not usable in production: > No transaction support. Statements like START TRANSACTION, RO
by pizza234 3y 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.
- zgk7iqea 3y agoOnly for the in-memory implementation. It is also specifically stated that you shouldn’t use the in-memory stub in production
- zachmu 3y agoYes, 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 https://github.com/dolthub/dolt
- deleted 3y ago[deleted]