A simple tool to handle MariaDB queries and reduce friction when interacting with query results.
- This project is in its early stages and likely has bugs or issues.
- This relies on the Python MariaDB connector version less than 2.0, thus does not have any asynchronous features.
Before running any SQL, all commented lines are removed in order to prevent accidental running of invalid SQL.
Errors are handled with a NeilError object which contains essentially the MariaDB errors which normally come as a tuple, as a usable object broken into the error message, SQL state, and error number which corresponds to what the MariaDB database would return to the user.
Result objects that gives back the sql statement ran, updated rows, returned data (if any), metadata, warnings, and errors.
A reusable object that allows the user to ensure they included needed parameters to connect to their database.
Creates a connection pool to reduce the overhead of creating connections when running many queries sequentially.
If you have more than one connection in your pool, you could run many queries concurrently with your NeilPool object.
The name for this project comes from Neil the Seal.
The image for Neil comes from this article from the New York Times.