Postgres integration #13
Description
When I use PostgreSQL as the main database instead of MySQL/MariaDB there is a problem if the dashboard contains an element from this package <livewire:pulse.usage-hours cols='4' />. I haven't tested the other databases (only these three), but according to the official documentation it should work: Pulse's first-party storage implementation currently requires a MySQL, MariaDB, or PostgreSQL database. If you are using a different database engine, you will need a separate MySQL, MariaDB, or PostgreSQL database for your Pulse data.
Nand based on this sentence at the beginning of the pulse documentation, I would expect this interface to work in combination with PostgreSQL. https://laravel.com/docs/12.x/pulse
SQLSTATE[42883]: Undefined function: 7 ERROR: function from_unixtime(integer) does not exist LINE 1: select sum(value) as requests, HOUR(FROM_UNIXTIME(bucket)) a... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. (Connection: pgsql, SQL: select sum(value) as requests, HOUR(FROM_UNIXTIME(bucket)) as hour from "pulse_aggregates" where "type" in (user_request) and "bucket" >= 2025-07-17 07:34:37 and "aggregate" = count group by "hour")