Kannan shared concerns regarding SQLite not being scalable since it doesn’t
support concurrency and uses a locking mechanism instead.
GN said it’s fine considering the use case and the audience of GNUKhata. For
personal accounting and small scale businesses where the accounting team
will be only a handful of people, concurrency issues wouldn’t be a deal
breaker. When we want to scale later, say for large scale enterprises, we
can switch to Postgres.
R2 asked about leaving the choice of databases to the users by developing the
app in a db-agnostic way. This could be possible, but needs more R&D
regarding what all database features we are going to implement.
As the frameworks and libraries are finalized (see last week’s minutes),
gnukhata-ng initial development can be started in the coming weeks.
The GNUKhata Odoo module initial phase development is completed with the
following features:
Financial reports (global + India localized)
GST reports (GSTR-1, GSTR-3B) with JSON export that can be uploaded to GST
portal.