luadbi
luadbi copied to clipboard
Multi-backend SQL database library for Lua
after check the source i see that all the modules (mysql, psql, sqlite, etc) has each one a directory, but odbc does not.. also search a little and only found...
Would be nice if the recently added lua5.4 support could be back-ported via the Prosody Debian repos. Thanks!
Can be reproduced with e.g. ``` lua db = assert(require"DBI".Connect("MySQL", "prosody", "prosody", "secret", "127.0.0.1", 3306)) s = assert(db:prepare("SELECT 1 LIMIT ? OFFSET ?")) assert(s:execute(1, 1)) ``` A MySQL to test...
Created a potential solution for the issue (#66) I just opened. Of course it might break preexisting applications.
When I execute: ``` dbi = require('DBI') conn = assert(dbi.Connect("MySQL", "", "user", "", "127.0.0.1", 3306)) user_stmt = assert(conn:prepare("SELECT NULL UNION SELECT 111")) user_stmt:execute() print(user_stmt:fetch()[1]) print(user_stmt:fetch()[1]) ``` It gives me: ```...
On a FreeBSD 13.0-RELEASE-p3 system, I'd like to use sqlite3. ``` $ tar -zxvf v0.7.2.tar.gz $ cd luadbi-0.7.2/ $ LUA_V=52 LUA_INC=/usr/local/include/lua52 SQLITE_INC=/usr/local/include/ make sqlite3 ``` ``` cc -c -o build/dbd_common.o...
The LuaDBI PostgreSQL driver does not appear to implement a [notice processor](https://www.postgresql.org/docs/current/libpq-notice-processing.html), so the `libpq` library uses its default behavior of printing these on `stderr`. This can be a bit...
In https://github.com/mwild1/luadbi/blob/73a234c4689e4f87b7520276b6159cc7f6cfd6e0/dbd/mysql/statement.c#L221 you are casting the integer 1 to a pointer as `is_null` is defined as a pointer. This makes no sense - the pointer (`0x0001` if you like) is...
It should be pretty easy to apply a Github webhook to automatically upload rockspecs to LuaRocks as soon as a version is tagged. I'm nearing completion of an unrelated project...