3 ms·

Don't tell me why, but I've developed an instinct that recognizes solutions that use Clickhouse under the hood :)

• HatchedLake721 2y ago
  Tell us more!
  • williebeek 2y ago
    It uses both, MySQL for the metadata and ClickHouse for the logs. The selfhost page explains a bit more about the architecture. edit: the connection to ClickHouse uses the MySQL driver, this is actually a very nice CH feature, you can connect to CH using the regular mysql or postgresql client tools. The PHP MySQL PDO driver works seamlessly. One catch, using advanced features like CH query timeouts requires a CTE function, check the model/txtlogrowdb.php file if you're interested.
• stingraycharles 2y ago
  Seems to be using MySQL instead? https://github.com/WillieBeek/txtlog/blob/master/txtlog/database/db.php https://github.com/WillieBeek/txtlog/blob/master/txtlog/data...
• deleted 2y ago
  [deleted]