Adam Johnson
Adam Johnson
A follow-up to #89 . Using MariaDB's `metadata_lock_info`, a re-entrant lock, like `threading.RLock`, could be implemented, by querying `INFORMATION_SCHEMA.metadata_lock_info` each time to determine if this is the first enter on...
MariaDB has it, and as mentioned in #42 it can be done with user variables with a double-query in vanilla MySQL so why not?
As per http://mysql.rjweb.org/doc.php/uniques , it could be useful to have a bitfield that is optionally compressed, for storing large sets. Or maybe it could be a bloomfilter field...
This is "the sane rule for timestamps" - everything as UTC unsigned ints. This is what #66 is using (though in milliseconds). As suggested in http://www.xaprb.com/blog/2014/01/30/timestamps-in-mysql/ . This could be...
Since MariaDB 5.3 `HANDLER` has supported prepared statements: https://mariadb.com/kb/en/mariadb/handler-commands/ "Starting from MariaDB 5.3 prepared statements work with HANDLER READ, which gives a much higher performance (50 % speedup) as there...
Considered in #39. `@a:=` and `@a` could be useful constructs, along with `LAST_VALUE` etc., for constructing complex queries in the ORM. https://mariadb.com/kb/en/mariadb/last_value/ We could then maybe add db-level ranking with...
When a core model gets big it may have large fields on it such as `TextField`s, which aren't useful for it the majority of the time. It would be good...
Just as `GlobalStatus` and `Lock` implement easy pythonic access to the data from the referred SQL commands, a `ProcessList` object could be useful for viewing all running queries, and killing...
Follow up to #9 - we can make it **faster** by supporting HandlerSocket as well, which is available for MySQL and distributed with MariaDB. The same ORM based API may...
If feeling particularly sadistic, an `XMLField` could be implemented. MySQL has two functions - `ExtractValue`, and `UpdateXML` that can be used for ORM lookups/updates.