HackerReposA FIELD GUIDE TO OPEN SOURCE
ProSponsor the shelf♧ 0
← Back to top all-time
sdementen
piecash
Python2019–2022
sdementen / piecash

piecash

Pythonic interface to GnuCash SQL documents

2Distinct people
2Mentions
0Explicit recommenders
346GitHub stars
REPOSITORY AT A GLANCE

What to know before exploring

What it is

Pythonic interface to GnuCash SQL documents

GitHub

Where it is used

No documented product use has been verified yet.

What people are saying

No recommendation phrase was found in the indexed comments.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

No other repository is repeatedly linked in the same discussions.

This week on Hacker News

Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 5:04:57 PM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by year2 dated mentions

Observed mentions: 2019-09-09 15:05:14 UTC to 2022-05-01 02:35:53 UTC.

012019-01-01 00:00:00 UTC to 2020-01-01 00:00:00 UTC (exclusive): 1 mentions; 0 submissions, 1 comments20192020-01-01 00:00:00 UTC to 2021-01-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments20202021-01-01 00:00:00 UTC to 2022-01-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2022-01-01 00:00:00 UTC to 2023-01-01 00:00:00 UTC (exclusive): 1 mentions; 0 submissions, 1 comments2022

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges
UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
PeriodStart (UTC)End (exclusive, UTC)MentionsSubmissionsComments
20192019-01-01 00:00:00 UTC2020-01-01 00:00:00 UTC101
20202020-01-01 00:00:00 UTC2021-01-01 00:00:00 UTC000
20212021-01-01 00:00:00 UTC2022-01-01 00:00:00 UTC000
20222022-01-01 00:00:00 UTC2023-01-01 00:00:00 UTC101

What Hacker News says

2 sources
I'm an avid user of GnuCash. Last I checked, their mobile app was basically abandoned (around 2018), and it had no way to use a SQL DB, even though the desktop can use SQLite3, MySQL, and Postgres [1]. So there was no easy way to use desktop AND mobile in a shared way. So, I made a small companion app called gnucash-helper [2]. It's a Python/Flask web app for doing the very basics of GnuCash, i.e. entering transactions, looking at their history, and checking balances. If you want to try it out, there's a demo of it on https://demo.checkyour.finance. The container it runs in is destroyed every 30 minutes, but that's enough time to play with it. It's very simple, but it does everything I need, to the point that I no longer have to open the desktop program. Your feedback is most welcome. I should say right now, though: it's more like beta so
Read the rest
ftware at this point. I haven't built the Docker container in a while, so the one on Docker Hub may or may not work. If anyone has any interest in contributing ideas or code to this, I would love to hear about it. Edit: A couple things I forgot to mention: - The backend for this is a .gnucash file that is saved in the sqlite file format. You can add your own into an S3 bucket, and this will write to it using Python's boto3 library. - There's no way as of yet to download the GnuCash file directly from the web app, but I would like to add that in the future. - The heart of this app is the Piecash Python library [3]. It lets you use Python to alter GnuCash files. References: [1]: https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files... [2]: https://github.com/bxbrenden/GnuCash-Helper [3]: https://github.com/sdementen/piecash
In GnuCash
I did make an attempt to switch from GnuCash to Firefly III, but had to switch back. As loathed as the GnuCash GUI is, Firefly III simply did not come close to the speed with which I could enter transactions in bulk via the keyboard. Plus, I was too used to GnuCash's data model and way of doing things. The reason I was drawn to FF III in the first place was because of its aesthetic appeal and visualization features. The graphing and reporting abilities of GnuCash are not to my taste. After some time, I settled down to converting from Gnucash to Ledger using PieCash (https://github.com/sdementen/piecash), and visualizing the ledger file using LedgerWeb (https://vifon.github.io/ledger-web/). A bit of a workaround, but can be scripted and works fine for me.
In Firefly III – Self-hosted financial manager

MAKE YOURSELF AT HOME

A few shortcuts

/
Search the collection
?
Open this guide
Esc
Close dialogs and navigation

Your saved repositories and interests stay in this browser.