aliens/scuttle/src/SemanticScuttle/Service/Bookmark.php, branch oni

Throw an error when changes can't be committed to the database

2024-06-11T07:11:58Z

I was testing and another process had the database open, so it couldn't commit changes. This wasn't apparent from the UI because it would just silently assume a commit went fine.

Throw an error if a bookmark can't be committed to the database

2024-06-11T07:00:19Z

Fix using SQLite as a database engine

2024-06-11T06:38:09Z

- The ‘sqlite_*’ functions don't exist anymore in PHP 8. They have been replaced with several ‘SQLite3*’ classes. - There are some differences between MySQL and SQLite queries that showed up while doing this work. These differences have been pushed into a QueryBuilder class so that the other database engines don't have to be modified. This is done in an ad-hoc basis for now, just to get things working. - SQLite doesn't support the ‘!’ negation operator used as ‘!ISNULL(...)’, instead I use ‘IIF(...)’. - SQLite doesn't support a ‘LEFT(...)’ function, instead I use ‘SUBSTRING(..., 0, ...)’. - The SQLite3 module doesn't provide a connection identifier, instead you use an object that represents the connection. - SQLite doesn't support the ‘ALL’ keyword (or at least doesn't support it in the same way MySQL does). Instead of ‘<> ALL ’ I use ‘NOT IN ’. - The ‘SQLite3*’ classes don't provide any way to determine how many rows have been returned without iterating through all of them, so any place that tries to figure out the rows beforehand just doesn't anymore. - All the database engine classes require a ‘QueryBuilder’ instance. The sqlite one uses a specialized one. I can't test most of these database engines, so I'm focusing on SQLite and MySQL/MariaDB for now.

Fix issue with urls ending in ‘/’ getting normalized wrong

2024-02-29T20:31:33Z

Normalizing them this way ruins the url by cutting off a character too many and making the url invalid.

Fix issue about ‘bVotes’ and ‘bVoting’ not having default values

2024-02-29T17:37:19Z

PHP 7.3 compat, bug fixes

2019-01-21T21:15:21Z

add option to get last modified date instead of creation date

2014-03-26T21:15:09Z

remove php4-style object reference passing

2013-03-17T21:22:16Z

Reverted changes of date() to gdate(), added tests to confirm existence of private RSS feed, and finalized changes to the user session usage with rss.php

2011-06-04T04:29:04Z

Altered tests to be more timezone friendly

2011-05-22T02:06:44Z