v1.6.1

SQLite v1.6.1

Diff since v1.6.0

Merged pull requests:

• Regenerate C API bindings for SQLite 3.40.0 (#315) (@metab0t)
• Add Test for Open Flags (#316) (@jeremiahpslewis)
• Deprecate @sr_str macro by Base.@raw_str and suggest users to switch. (#318) (@metab0t)
• Fix wrong default value of keyword argument in docstring (#320) (@metab0t)
• Escape table name in SQLite.tables (#323) (@metab0t)
• Make open URL test re-entrant (#325) (@metab0t)
• Upgrade C API binding to SQLite 3.41.0 (#326) (@metab0t)
• Use anonymous function to register UDF and avoid name clash (#333) (@metab0t)
• Update C API to 3.43.0 (#334) (@metab0t)
• Avoid using cfunction closure (#336) (@metab0t)
• Update Documenter version for doc building (#339) (@Seelengrab)
• relax bind! Vector{UInt8} -> AbstractVector{UInt8} (#340) (@maxfreu)

Closed issues:

• Open flags (#314)
• deprecate @sr_str in favour of Base.@raw_str? (#317)
• Table Name Problem (#322)
• Clash between independent registered functions (#331)
• UDFs don't work on ARM (#335)

v1.6.0

SQLite v1.6.0

Diff since v1.5.1

Closed issues:

• Outdated documentation page (#310)

Merged pull requests:

• Add strict mode for more type-stable results if desired (#304) (@quinnj)
• Refine docstring of SQLite.Stmt (#311) (@metab0t)
• Fix doc deploy (#312) (@quinnj)

v1.5.1

SQLite v1.5.1

Diff since v1.5.0

Closed issues:

• SQLite - error regression in Julia 1.8 vs Julia 1.7 (#306)

Merged pull requests:

• Manually preserve cconvert values until sqlite3_step (#308) (@quinnj)

v1.5.0

SQLite v1.5.0

Diff since v1.4.2

Closed issues:

• Type specialized Tables.jl reader (#224)
• Unsupported SQLite declared type BOOLEAN (#279)
• Error registering SQLite.regexp on Apple M1 (#282)
• Stale statements with DBInterface @prepare (#301)

Merged pull requests:

• Remove unused argument in test helper function (#294) (@rikhuijzer)
• Clang.jl generated bindings and internal refactor (#296) (@metab0t)
• Use JuliaFormatter.jl to format all code (#297) (@metab0t)
• Add .codecov.yml to ignore generated C API bindings (#300) (@metab0t)
• Allow selection of constraint conflict resolution algorithm in SQLite.load! (#302) (@Seitzal)
• Fix warnings on master (#305) (@quinnj)
• Ensure table row doesn't get GCed when inserting via load (#307) (@quinnj)

v1.4.2

SQLite v1.4.2

Diff since v1.4.1

Closed issues:

• Drop BinaryProvider.jl (#287)
• Support for begin/commit statements? (#292)
• Cut a new release to drop BinaryProvider.jl dependency (#298)

Merged pull requests:

• Drop Julia < 1.3 (#288) (@jeremiahpslewis)
• Include transaction related calls in docs (#293) (@paulmelis)

v1.4.1

SQLite v1.4.1

Diff since v1.4.0

Closed issues:

• tables(db) for empty database should be (names=[],) (#209)
• What is the syntax to bind variables? (#283)

Merged pull requests:

• Add DBTables type (#269) (@jeremiahpslewis)
• Remove warning in juliatype (#290) (@ziotom78)

v1.4.0

SQLite v1.4.0

Diff since v1.3.0

Closed issues:

• "Custom Scalar Functions" - TEXT vs. BLOB (#147)
• TypeError in select with missing values (#244)
• SQLite.jl appears to be 400 times slower than Python's sqlite3 (#246)
• sqlite3_open seems to dislike AbstractStrings? (#265)
• How to get the schema of a table? (#272)
• Repeat calls to load!(...) fail (#274)
• load!(db ; analyze=true) is broken (#276)
• Tables.columns seem to flatten columns (#280)
• ArgumentError: 'Int32' iterates 'Int32' values, which doesn't satisfy the Tables.jl AbstractRow interface (#281)

Merged pull requests:

• Convert DB input to String to try and avoid any weirdness (#266) (@quinnj)
• Allow sqldeserialize to return non-T to allow value/schema mismatch (#267) (@quinnj)
• Support DBInterface.jl v2.5 (#268) (@quinnj)
• Use @testsets (#273) (@jeremiahpslewis)
• Report the failing INSERT when load!() errors (#277) (@bks-nist)

v1.3.0

SQLite v1.3.0

Diff since v1.2.0

Closed issues:

• Handle locked database (#163)
• After close database, its filename should be cleared too. (#194)
• The function juliatype not cover fully? The type name completely follows the table creating statement. (#219)
• Nothing in place of Missing causes various errors (DBInterface.execute function). (#221)
• Exception when opening sqlite DB with blobs (#222)
• Any plans for an ORM? (#238)
• Calling collect outputs missing everywhere (#239)
• load! seems to ignore foreign key errors when inserting data. (#240)
• Failing test (#241)
• Broken regex in juliatype v1.1.4? (#242)
• Request a variant of load! that executes REPLACE on each row rather than INSERT. (#243)
• Incorrect handling of string types with length limits (#245)
• Cannot read empty blob (#248)
• Weird iteration behavior (#251)
• Allow threadsafe insertion of blobs (#255)
• SQLite.table always gives error message. (#258)
• SQLite 1.2.0's load! eats the first row of rows in the unknown schema case (#259)

Merged pull requests:

• don't try deserializing short blobs (#249) (@aplavin)
• fix string outputs from UDF (#250) (@aplavin)
• Make serialization of blobs threadsafe (#256) (@herzfeldd)
• Ensure schema-less tables have all rows respected in load! (#260) (@quinnj)
• Convert NULL type columns to Julia Missing type (#261) (@quinnj)
• Ensure rows are only valid while currently being iterated (#262) (@quinnj)
• Add replace keyword arg to SQLite.load! (#263) (@quinnj)
• Make type affinity detection more robust (#264) (@quinnj)

v1.2.0

SQLite v1.2.0

Diff since v1.1.4

Closed issues:

• WeakRefStrings dependency (#247)
• Ensure unique column names in query result by default (#253)
• New release to support WeakRefStrings version 1.0 (#257)

Merged pull requests:

• By default, make query column names unique (#254) (@quinnj)

v1.1.4

SQLite v1.1.4

Diff since v1.1.3

Closed issues:

• Bug related to 32 bit Integers? (#207)
• Please provide more comprehensive docs for execute (#233)
• Select col from sys.tables? (#235)

Merged pull requests:

• Ensure bit integer values are returned as Int64 (#234) (@quinnj)
• Handle nothing as missing in binding. (#236) (@BenjaminGalliot)