Connect to PostgreSQL

[Aesth]

I don't understand what's going on. There's a configuration file.

{ "DATABASE_URL":"postgres://user:password@localhost:5432/my_db" ,"LISTEN_ON":"0.0.0.0.0:8088" ,"port":"8088" ,"web_root":"./Test" } 

SQLPage doesn't return any errors when it starts.

[2025-10-31T13:37:08.990Z INFO sqlpage::app_config] Configuration loaded from \?\C:\Users\***\Documents\Work\SQLPage\sqlpage
SQLPage v0.39.0 started successfully!

View your website at:
http://localhost:8088/
(also accessible from other devices using your IP address)

Create your pages with SQL files in:
./Test

Happy coding!

When querying SQL files, it still connects to the SQLite database in the SQLPage subdirectory, sqlpage.db. What am I doing wrong?

[lovasoa]

There is no bad question ! I restored your initial question above. If you had this issue someone else might have it too in the future, and stumble upon this answer.

The problem is that the configuration file expects lowercase configuration keys. the correct syntax is

{ "database_url":"postgres://user:password@localhost:5432/my_db" }

not

{ "DATABASE_URL":"postgres://user:password@localhost:5432/my_db" }

Environment variables are uppercase, but keys in sqlpage.json are lowercase.

[Aesth]

Hello Ophir, Since I mostly work on Windows, I'm used to the fact that there's generally no difference between upper and lower case. But in one example, I saw that it was written in upper case and automatically typed it. The example, I think, was for a different file — ".env" and there was an equals sign between the names. It only took me a moment to realize that I was mistaken, and the question immediately seemed stupid; I just need to be more careful. So I decided to delete it; it's unlikely anyone else will make the same mistake. In any case, thank you for your help and the product; I really liked the concept. I plan to actively use it in my practice.

[lovasoa]

You are welcome, let me know if I can be of any help !