The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
3.005     2021-02-15 21:47:59 EST
  - Add query_p, select_p, insert_p, update_p, delete_p Mojo::Promise-returning methods to Mojo::SQLite::Database.
    These are for API compatibility with Mojo::Pg and do not provide non-blocking query functionality. (#20, Stefan Adams)
  - Use Mojo::Promise in tests instead of the deprecated and decored Mojo::IOLoop::Delay (#20, Stefan Adams)

3.004     2020-07-22 22:50:43 EDT
  - The Mojo::SQLite::Migrations sqlite attribute and the
    Mojo::SQLite::Transaction db attribute are now weak attributes, increasing
    the required version of Mojolicious to 8.03.
  - Defer loading of Mojo::IOLoop unless the callback compatibility API is
    used.
  - Newly created mojo_migrations tables from Mojo::SQLite::Migrations will use
    a primary key.
  - Recognize -json parameters in queries.

3.003     2019-10-01 15:49:43 EDT
  - Increase DBD::SQLite dependency to 1.64 to support configuring
    double-quoted string literals.
  - Disable double-quoted string literals for all connections.
    https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted
  - Change default SQL::Abstract identifier back to double quote.

3.002     2019-06-21 17:41:35 EDT
  - Changed default SQL::Abstract identifier quoting character to `, as double
    quoted identifiers may be interpreted as string literals if they are not
    valid identifiers. https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted

3.001     2018-07-20 20:25:12 EDT
  - Increase DBD::SQLite dependency to 1.54 for FTS5 support.
  - Add db attribute to Mojo::SQLite::Results and use it to prevent connections
    from being cached for reuse while results are active.
  - Add sql_for method to Mojo::SQLite::Migrations.

3.000     2017-07-20 01:16:50 EDT
  - Changed default for max_connections attribute to 1.
  - Added support for sharing the database connection cache between multiple
    Mojo::SQLite objects. (based on Mojo::Pg 4.0)
  - Added parent attribute to Mojo::SQLite.
  - Fixed database connection leak with automatic migrations.
  - Removed deprecated Mojo::SQLite::PubSub and associated methods and attributes.
    SQLite's serverless nature means it does not have the ability to support
    client notifications, so it is not possible to implement an efficient
    pubsub system as in for example PostgreSQL, Redis, or websockets.

2.002     2017-06-01 14:16:34 EDT
  - Add no_wal option to prevent enabling WAL mode on connection.

2.001     2017-02-18 15:36:16 EST
  - Set name_sep in default SQL::Abstract object to support proper quoting of
    table and column names.

2.000     2017-02-11 17:03:53 EST
  - Add support for generating queries with SQL::Abstract. (based on Mojo::Pg 3.0)
  - Add abstract attribute to Mojo::SQLite.
  - Add delete, insert, select, and update methods to Mojo::SQLite::Database.

1.004     2017-01-17 00:10:51 EST
  - Use Mojo::File from Mojolicious 7.15 instead of deprecated
    Mojo::Util slurp function. (#9)

1.003     2016-12-11 16:30:31 EST
  - Add links to alternatives for deprecated Mojo::SQLite::PubSub.

1.002     2016-11-30 11:17:56 EST
  - Improved contextual caller information in query error messages. (#6)
  - Fix memory leak when reusing the same database handle many times. (#7)

1.001     2016-11-15 02:32:27 EST
  - Deprecate Mojo::SQLite::PubSub and associated methods and attributes.
    SQLite's serverless nature means it does not have the ability to support
    client notifications, so it is not possible to implement an efficient
    pubsub system as in for example PostgreSQL, Redis, or websockets.

1.000     2016-08-17 21:01:31 EDT
  - Bump version to 1.000 as this distribution is considered stable
  - Added database_class attribute to Mojo::SQLite and results_class attribute
    to Mojo::SQLite::Database to make it easier for these classes to be extended
  - Fixed a few fork-safety bugs and memory leaks in Mojo::SQLite::PubSub

0.022     2016-07-14 16:59:36 EDT
  - Improve expand performance slightly
  - Add support for encoding and decoding of JSON notifications
  - Add json method to Mojo::SQLite::PubSub
  - Fix bug where poll_interval in Mojo::SQLite::PubSub was not correctly used
  - Fix case where notifications from other connections could be lost

0.021     2016-02-15 01:58:40 EST
  - Lower dependency on DBI to 1.627
  - Remove dependency on URI::QueryParam

0.020     2016-02-14 17:53:55 EST
  - Bump dependency on DBD::SQLite to 1.50 for JSON1 extension support
  - Add support for json parameters to query method in Mojo::SQLite::Database
  - Add expand method to Mojo::SQLite::Results to decode json columns
  - Add auto_migrate attribute to Mojo::SQLite (from Mojo::Pg)
  - Add tables method to Mojo::SQLite::Database (from Mojo::Pg)

0.019     2015-11-25 22:45:25 EST
  - Added support for removing all subscribers of a channel at once in unlisten
    method in Mojo::SQLite::PubSub
  - Mojo::SQLite::Migrations now throws an error if the currently active
    version is greater than the latest version
  - Added finish method to Mojo::SQLite::Results

0.018     2015-09-21 13:44:30 EDT
  - Fixes for tests under win32

0.017     2015-09-20 17:24:44 EDT
  - Fix parsing of options from connection strings
  - Allow passing a hashref of options in from_filename

0.016     2015-09-20 16:51:53 EDT
  - Use URI::db to parse connection strings to allow sqlite: connection strings

0.015     2015-09-12 00:13:53 EDT
  - Minor pubsub fixes

0.014     2015-09-11 20:25:25 EDT
  - Add Mojo::SQLite::PubSub and listen/notify implementation in Mojo::SQLite::Database

0.013     2015-09-02 02:44:36 EDT
  - Cache rowid for successful inserts in Results objects as last_insert_id

0.012     2015-08-31 18:26:47 EDT
  - Include better context for DB error messages from $db->query and migrations
  - Switch installer to Module::Build::Tiny

0.011     2015-08-13 20:43:37 EDT
  - Simplify Results refcounting
  - Pass undef instead of broken Results object to callback if statement
    prepare failed

0.010     2015-08-08 22:50:06 EDT
  - Create a tempdir for temporary databases
  - Use immediate locking for migrations instead of exclusive
  - Run query callbacks using next_tick instead of immediately
  - Don't call finish in Results destructor while other Results objects refer
    to the statement handle (GH #2)

0.009     2015-08-05 12:28:48 EDT
  - Simplify some code and examples with Mojo::Base::tap

0.008     2015-08-03 19:23:49 EDT
  - Use and recommend URI to portably parse filenames into URLs
  - Add from_filename method

0.007     2015-08-01 15:17:22 EDT
  - Clarify use of URLs in connection strings

0.006     2015-07-28 23:54:45 EDT
  - Fix results rows() method to return statement handle rows
  - Make scheme optional for from_string() (and thus the constructor)

0.005     2015-07-28 21:59:23 EDT
  - Allow specifying bind types for query parameters

0.004     2015-07-28 20:48:04 EDT
  - Depend on DBI explicitly
  - Remove List::Util dependency
  - Add blog example

0.003     2015-07-28 12:56:30 EDT
  - Minor migrations fixes

0.002     2015-07-28 12:39:12 EDT
  - Allow passing callback to query()

0.001     2015-07-28 02:48:42 EDT
  - First release