v1.8.1

SQLite v1.8.1

Diff since v1.8.0

Merged pull requests:

• Scan multiple rows for determining type in strict mode (#349) (@evetion)

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)