Restructure is a rewrite of my previous SQLite Swift library, Structure. The framework works on Swift 5 for iOS, macOS, and tvOS. It’s highly opinionated, because it does exactly what I wanted it to do, while also staying true to how SQLite behaves.

Restructure has the following features:

  • Easy type conversion for common Swift data types.
  • Simple handling of more complex data types, like arrays and dates.
  • Statements are Sequences, making data iteration a part of the language.
  • Statements are Encodable, making data structure transformation to SQLite statement simple.
  • Rows are Decodable, making SQLite results easily transformable to data structures.

Check out the code on GitHub. There you will find examples, tests, and installation instructions.

Version History

2.1.2 - 2023-09-07


  • Closing a file-backed database no longer deletes the underlying file.
  • In WAL journal mode, closing the database causes a WAL checkpoint.

2.1.1 - 2023-09-07


  • Storing a Statement no longer causes a crash when cleaning up.
  • The UPPER function properly handles memory management of strings.

2.1.0 – 2020-08-16


  • sqliteVersion fetches the underlying SQLite version string.
  • Dynamic member lookup is enabled for Row, allowing for direct access to values via property notation.


  • has been removed because of defensive configs.

2.0.0 – 2019-09-12


  • AutoVacuum dictates the automatic vacuuming mode.
  • JournalMode dictates the journaling mode used by the database.
  • SecureDelete dictates the data deletion mode.
  • incrementalVacuum can be used with AutoVacuum.incremental to affect vacuuming.
  • vacuum causes a full database vacuum to occur.


  • Restructure is now a SwiftPM project. All legacy build tools have been removed.
  • The Restructure constructor takes a defaulted parameter for a journal mode.

1.0.0 – 2019-06-20


  • Created the primary Restructure object for maintaining SQLite databases.
  • Created the Statement object for working with prepared SQLite statements.
  • Created the Row object for working with resultant rows from a Statement.
  • Created the RowDecoder and StatementEncoder for using Swift’s Decodable protocols.