What are you doing!
As of last year I decided to start keeping a record of my finances and setting a monthly budget. Google Sheets was great at first, but as things got more complicated with interest/stocks/etc, I decided to move to using some actual accounting software.
GnuCash, is free, the learning curve isn't too steep, and it's ugly as hell I also hate the fact that I can't view or update my details from anywhere like I could with Google Sheets.
The goal of this project will be to setup a locally hosted webpage capable of pulling and pushing data to my PostgreSQL GnuCash Database, and to display that data in a much more eye pleasing way than this:
Like seriously, ew.
Getting Started
You will need to install:
For the top 3 items in the list, EnterpriseDB has conveniently packaged it all together, Download Here
There's plenty of guides out there on how to setup the above programs, so I'll leave that out of this tutorial. The only thing I'll add is that you probably want to set your apache server to run as a service:
If you used the EnterpriseDB installer to install Apache, your Apache directory will be "C:\Program Files (x86)\PostgreSQL\EnterpriseDB-ApachePHP\apache", so go there for any initial config setup you need to do (e.g. selecting your web directory)
Next download the GnuCash Website and put the contents in the root of your web directory (whatever you set that to in httpd.conf)
If you have Git, you can clone it with: https://github.com/S0ULphIRE/GnuCash.git
Modify line 35 of index.php to reflect your Postgres login details and the name of your gnucash database, then you should be good to go! Browse to http ://localhost (or whatever the server is set to in httpd.conf again) and you should see your pretty data
I'll be modifying the github repo over the next few weeks to slowly tweak it better, and hopefully I haven't forgotten anything in the setup that was required.
As of last year I decided to start keeping a record of my finances and setting a monthly budget. Google Sheets was great at first, but as things got more complicated with interest/stocks/etc, I decided to move to using some actual accounting software.
GnuCash, is free, the learning curve isn't too steep, and it's ugly as hell I also hate the fact that I can't view or update my details from anywhere like I could with Google Sheets.
The goal of this project will be to setup a locally hosted webpage capable of pulling and pushing data to my PostgreSQL GnuCash Database, and to display that data in a much more eye pleasing way than this:
Like seriously, ew.
Getting Started
You will need to install:
- Apache Httpd (Web server)
- PHP (To connect our webpage to our database)
- PostgreSQL (To store our GnuCash data)
- Bootstrap (Because who wants to write everything from scratch )
For the top 3 items in the list, EnterpriseDB has conveniently packaged it all together, Download Here
There's plenty of guides out there on how to setup the above programs, so I'll leave that out of this tutorial. The only thing I'll add is that you probably want to set your apache server to run as a service:
Code:
/path/to/httpd.exe -k install
Next download the GnuCash Website and put the contents in the root of your web directory (whatever you set that to in httpd.conf)
If you have Git, you can clone it with: https://github.com/S0ULphIRE/GnuCash.git
Modify line 35 of index.php to reflect your Postgres login details and the name of your gnucash database, then you should be good to go! Browse to http ://localhost (or whatever the server is set to in httpd.conf again) and you should see your pretty data
I'll be modifying the github repo over the next few weeks to slowly tweak it better, and hopefully I haven't forgotten anything in the setup that was required.
Last edited: