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