SQLite.jl

SQLite.jl copied to clipboard

Open flags

2

Please allow open flags to be specified for `SQLite.DB()`. I do not necessarily want to create a new file if path does not exist.

rongcuid

Binding signed/unsigned integer causes different results

4

For instance a query like so: ```sql SELECT * FROM table WHERE x = ? ``` Binding `0x1000` (which is `UInt16`) and `Int(0x1000)` yield different results.

rongcuid

@quinnj - I understand that `SQLite.load!` will append data to an existing table. Right? Maybe this should be made clear in the docstring?

bkamins

Convert date/datetimes to text when storing

5

see discussion: https://discourse.julialang.org/t/datetimes-and-sqlite-jl-encoding/16412/3

quinnj

[BUG] Query Not Running Using SQLite.jl - Runs within `litecli`

2

So, I have the following SQL query: ```sql DELETE FROM "COHORT" WHERE cohort_definition_id = 1; INSERT INTO "COHORT" SELECT 1 AS "cohort_definition_id", "drug_era_7"."subject_id", "drug_era_7"."cohort_start_date", "drug_era_7"."cohort_end_date" FROM ( SELECT "drug_era_6"."person_id" AS...

TheCedarPrince

Explicit GC.gc() needed for SQLite.DB to become really out of scope.

2

Otherwise at the end of program execution sqlite database remains in use by Julia REPL. And according to the doc: "The SQLite.DB will be automatically closed/shutdown when it goes out...

MarieJC

Add sqlite3_progress_handler() to API for Progress bar callback

1

The use of `SQLite.@register cxn func` is awesome. Is there any possibility that a progress bar for queries will be implemented via the `progress_handler` that [sqlite3 offers](https://sqlite.org/c3ref/progress_handler.html)? I would imagine...

chaxor

Add support for `TEXT_DATETIME`

1

For my DB I'm getting: ``` ┌ Warning: Unsupported SQLite declared type TEXT_DATETIME, falling back to String type └ @ SQLite ~/.julia/packages/SQLite/aDggE/src/SQLite.jl:416 ``` I guess `TEXT_DATETIME` should be supported by...

CGenie

I think a method able to create a table with a primary key could be very helpful, but I didn't find any -- I am sorry if such a method...

G-R-Martins

Consider dropping SQLite.jl APIs entirely in favor of DBInterface.jl

3

It seems like there are a number of errors / user challenges which arise as a result of the overlapping / intersecting API domains. It might make sense (as part...

jeremiahpslewis