i want to connect esp8266 data reading to postgresql database locallyhost. Then I want to display this database on a local website so that it can be accessed at any time without an internet connection. Are there any suggestions or steps I can follow?

I know of a similar project which uses Node JS, Laravel, and MySQL to create an edge website. The website can receive data from IoT devices (Edge Node) then store it in a database and display it on the edge web without an internet connection, and existing data can also be sent to the cloud website by pressing a button.
I want to create a similar edge system using a postgresql database in the hope that data locally can also be sent directly to an odoo erp that uses the same postgresql database