v1.8.0

SQLite v1.8.0

Diff since v1.7.1

Merged pull requests:

• Add backup API with configurable sleep (#347) (@quinnj)

v1.7.1

SQLite v1.7.1

Diff since v1.7.0

Merged pull requests:

• add strict option to create_table! and load! (#343) (@aplavin)

Closed issues:

• v1.6 errors on M1 Macs: ERROR: cfunction: closures are not supported (#319)
• Add STRICT flag to createtable! (#327)
• SQLite.load! fails inside transaction (#341)

v1.7.0

SQLite v1.7.0

Diff since v1.6.1

Merged pull requests:

• Don't throw out-of-memory error on a closed DB (#337) (@evetion)
• Fix and test strict keyword. (#346) (@evetion)

Closed issues:

• Misleading ERROR: SQLiteException("out of memory") caused by closed database (#324)
• Partial execution of the SQL query (#332)
• [Question] How can I save a vector as raw binary blob? (#338)
• DBInterface.execute type unstable (#342)

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)