luasql

luasql copied to clipboard

can't find "libpq-fe.h" for postgres on ubuntu18.04

1

pg in run in docker, so host(a Notebook ) is not install pg, but just install libpg-dev so libpq-fe.h is exists at /usr/include/postgresql but luasql install can't find it, even...

xuqinghan

Sorry this isn't a bug, but does anybody have compiled dlls for one of the latest versions? ie compatible with latest lua. Thanks a lot

teajaysee

Hi. I'm having a problem with out-of-memory errors when connecting repeatedly to a MariaDB. This is within [Domoticz](https://www.domoticz.com) using: Lua: 5.2.2 lua-sql-mysql - Version: 2.3.4-1 libmariadbclient18 - Version: 10.1.37-0+deb9u1 Debian...

krejkrejkrej

Hi all, We're running luasql 2.3.0 under lua 5.1.4, which is called by asterisk (open source PBX) as a dial plan interpreter. This has worked perfectly for us for years....

WhiteyDude

* New con:prepare method returning a prepared statement * Both con:execute and stmt:execute now take optional arguments to pass to the SQL query e.g. ```lua stmt = con:prepare("INSERT INTO T1(F1,F2)...

blumf

Reusable Prepare Statements on MySQL (plus basic support for postgres and sqlite3)

2

This pull request is based on the PR #99, however this one adds additional support for reusing prepared statements. Example: ```lua local driver = require 'luasql.mysql'.mysql() local conn = assert(driver:connect('test'))...

fcr--

Instead of hardcoding include&library paths, how about using pkg-config?

fcr--

Basic support for prepared statements in postgres, sqlite3 and mysql.

6

With this modification we can enjoy the security benefits of having prepared-statement-alike additional parameters. To do this, the additional parameters should be passed after the statement in the execute method....

fcr--

PostgreSQL bytea returned as hex string

1

For example: ```sql create table test(col bytea); insert into test values ('abc'::text::bytea); select * from test; ``` shows ``` col ---------- \x616263 (1 row) ``` When read using LuaSQL, the...

ghost

ODBC Connection String

4

Hello, for an ODBC connection I use in Excel following string: "DSN=DataSource;Driver={};DBQ=.;UID=mngr;PW=xxxx;DOMAIN=HS;RemoteHost=HS;CPU=N;LAN=N" ... and get a connection to the database. In Lua I wrote: local driver = require"luasql.odbc" local env...

ht250763