cl-dbi

cl-dbi copied to clipboard

MySQL memory leak

2

``` (let* ((pq (dbi:prepare conn "SELECT * FROM visit")) (query (dbi:execute pq nil))) (dbi:fetch-all query)) ``` above code run in hunchentoot will lead to memory leak in MySQL https://blog.actorsfit.in/a?ID=01800-28830ddf-a436-4fff-b97d-d952487c8948 the...

simon639

fixes #73

fukamachi

Make ":binds" of "retrieve-by-sql" into an optional param

2

Hi! Looking at `(defgeneric retrieve-by-sql (sql &key binds)` it seems that `:binds` can be `&optional` instead of a key param: ```lisp (mito:retrieve-by-sql "select * from users where email = $1"...

TatriX

One stupid question: with **PostgreSQL**, how would you get the id of the newly created record? ```SQL (with-connection (db :school) (execute (insert-into :students (set= :last_name "Uzumaki" :first_name "Naruto" :address "Ever...

asarch

Functions connect-cached and get-connection-pool are not thread-safe

4

Because of that, Ultralisp sometimes fails with this error: ``` failed AVER: (= (HASH-TABLE-COUNT SB-IMPL::TABLE) SB-IMPL::HWM) This is probably a bug in SBCL itself. (Alternatively, SBCL might have been corrupted...

svetlyak40wt

Would it be possible to add something like: [https://rdrr.io/cran/DBI/man/dbExistsTable.html](dbExistsTable) ? thanks!

slyrus

f2cfb60: 'Converts Calls With Parameters to `&optional` instead of `&rest`' broke my code

1

It's nice that there's a higher performance version of execute now, but this could have been done by adding a new function and preserving the old behavior. Now I have...

slyrus

Range of elements

1

How could I do this query (from PostgreSQL SQL dialect)? ```SQL SELECT * FROM student ORDER BY id DESC LIMIT (20-10+1) OFFSET 10; ```

asarch

Preparing statement with lists

2

I have the following issue: ``` (dbi:with-connection (con :postgres :username "test" :database-name "test") (dbi:execute (dbi:prepare con "SELECT a, b FROM T WHERE c = ? AND a IN ? AND")...

simkoc

I'm still in the process of tracking things down, but my code used to work before: ``` 02d7b41 | * | @ Refactored the way how transactions and savepoints are...

slyrus