Commit Graph

21 Commits

Author SHA1 Message Date
Frédéric Guillot 5e4d506b28 Enable Sqlite WAL mode by default
WAL provides more concurrency as readers do not block writers and,
a writer does not block readers. Reading and writing can proceed concurrently.

This change might reduce the number of errors related to locked databases.

For reference: https://sqlite.org/wal.html
2023-02-10 20:02:18 -08:00
Joe Nahmias 33852e9ea0 feature: add Microsoft SQL Server database support
can be used via the pdo_dblib or pdo_odbc extensions.
requires Microsoft SQL Server 2016 or later.

* add schema/migrations
* add database provider
* add setup check for pdo module needed by selected driver (dblib/odbc)
* add default config doc
2022-10-29 21:11:15 -07:00
Frédéric Guillot d8c625c856 Use utf8mb4 encoding for MySQL instead of utf8 2018-04-12 13:41:32 -07:00
Frédéric Guillot 0d578171fe Add timeout parameter for database connection 2018-02-14 10:18:27 -08:00
Frédéric Guillot d35d5beee2 Add option to disable Mysql SSL server verification 2018-01-11 14:01:32 -08:00
Frederic Guillot f2fd5d75d9
Add config parameter to toggle automatic SQL migrations
- Add two command line opterations to show schema version
and to execute SQL migrations
- Add new configuration parameter to enable or disable
SQL migrations
2016-12-02 19:16:50 -05:00
Frederic Guillot 8314c99b56 Added QueueManager to process background jobs 2016-05-23 20:43:51 -04:00
Frederic Guillot 68c087e85c Update PicoDb 2016-05-14 22:19:10 -04:00
Frederic Guillot 400e230881 Added support for Mysql SSL connection 2016-05-06 19:19:05 -04:00
Frederic Guillot 004fde30f7 Update SQL dumps and improve schema migration process 2016-03-27 16:21:15 -04:00
Frederic Guillot a675271ad7 Rewrite of session management 2015-11-15 12:50:33 -05:00
Frederic Guillot ad55e6ede5 Remove exit expression in database provider 2015-10-17 22:31:04 -04:00
Frederic Guillot 8c532efd5f Run php-cs-fixer on the code base 2015-10-17 10:09:03 -04:00
Frederic Guillot 9c9ed02cd7 Change namespace to add Kanboard as prefix 2015-10-13 22:19:17 -04:00
Frederic Guillot 1823430d13 PicoDb update 2015-06-27 00:00:43 -04:00
Frederic Guillot 1a0465cb57 Fix PhpAnalyzer issues 2015-05-24 16:47:41 -04:00
Frederic Guillot 313318a40d Add config parameter for custom database port 2015-03-05 21:37:57 -05:00
Frédéric Guillot 3076ba22dd Fix bugs, improve perfs and use SimpleLogger instead of Monolog 2015-01-02 17:19:13 -05:00
Frédéric Guillot 198f8d6a8e Add debug option 2014-12-31 12:56:29 -05:00
Frédéric Guillot 1522be603b Fixs after replacing the event dispatcher 2014-12-27 19:23:51 -05:00
Frédéric Guillot 17dc5bdc9e Move events handling to Symfony\EventDispatcher 2014-12-27 19:10:38 -05:00