pgbadger
LedgerSMB
Our great sponsors
pgbadger | LedgerSMB | |
---|---|---|
6 | 9 | |
3,369 | 391 | |
- | 6.4% | |
7.9 | 9.8 | |
about 1 month ago | 1 day ago | |
Perl | Perl | |
PostgreSQL License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgbadger
-
Site down due hosted on digitalocean
It might also help to use pgbadger or something similar to process your postgres logs and see whether some event is aligned with your outages.
-
SQL: 2023 Has Been Released
Interestingly, when a place does get to the point where the single instance has capacity issues (after upgrading to EPYC and lots of flash drives) then other non-obvious stuff shows up too.
For example, at one place just over a year ago they were well into this territory. One of weird problems for them was with pgBadger's memory usage (https://github.com/darold/pgbadger). That's written in perl, which doesn't seem to go garbage collection well. So even on a reporting node with a few hundred GB's of ram, it could take more than 24 hours to do a "monthly" reporting run.
There wasn't a solution in place at the time I left, so they're probably still having the issue... ;)
- Moving from Oracle to Postgres, what should I know?
-
What are the top 3 most useful things that you have hosted over the years?
First of all I used a profiler (pgbadger and netdata) to figure out where the lags were coming from. I then tried the usual stuff (increasing shared_buffers, max_wal_size, min_wal_size from their ultra low defaults), but the biggest performance gain came from moving the database from eMMC to a mechanical hard drive :-D
-
Best way to find queries that might benefit from indexes.
Look into PgBadger (a log parser/analyser): https://github.com/darold/pgbadger
LedgerSMB
-
Free quick books alt.
All software costs money to make and maintain. Allot of things that are 'free' like gmail are making money by mining your data, or they have limited features and want you to pay to upgrade. Then there is opensource software that is free and the code gets peer reviewed, so you can trust its not spy ware. I have seen people use gnucash its free and opensource. https://www.gnucash.org/ also more sophisticated packages are Sql-ledger https://sql-ledger.com/ and Ledgersmb https://ledgersmb.org/
-
Accounting/bookkeeping software?
I use - and develop - https://ledgersmb.org/ ; if you host it yourself (it can be done at a few dollars per month, or free, on your own laptop), it's definitely less costly than many of the commercial propositions.
-
Trust Fund Accounting Software.
LedgerSMB has fund accounting; https://ledgersmb.org as part of its accounting dimensions, it can track how funds (donations, entitlements) are being used by the fund. The software is open source and fund tracking was built inspired by the requirements for the Software Conservancy (https://sfconservancy.org/).
-
Creating a bookkeepng software
Before you start writing anything from scratch, please know that *many*, *many*, *many* have done so before you. There's some really good open source software that - instead of writing your own from scratch - you could adapt to suit your needs. E.g. the software that I contribute to (LedgerSMB) is on a roadmap for extensibility by businesses that need that type of flexibility (with usable default configurations).
-
Why do you use Quickbooks (or the software you do use at the moment)?
I use open source software to do my books. First of all because I get to keep full control of my own data. But the added benefit is that I can tweak the software when I don't like how it was originally created. That's how I ended up being one of the main developers of the software that I have been using to do my books: https://ledgersmb.org/. Others use this software because they feel the community - although small - is very supportive. Some claimed they got better answers than from Intuit or Xero (for some comments from others, see the testimonials on the site or at https://alternativeto.net/software/ledgersmb/about/)
-
Alternatives to akaunting
Have you tried: https://ledgersmb.org/
- Self-hosted accounting software with SSO and/or LDAP support.
- QuickBooks Desktop moves to subscription model
-
Recommendation for modern book keeping solution?
Try https://ledgersmb.org. We are moving to this open source platform and will self-host. You can have it hosted however. It is less complex than Odoo and yet full multi-user and full-on double-entry accounting -- including for us the all-important project accounting (which is helpful especially for client expense reimbursement).
What are some alternatives?
pgaudit_analyze - PostgreSQL Audit Analyzer
Odoo - Odoo. Open Source Apps To Grow Your Business.
Mailcow - mailcow: dockerized - 🐮 + 🐋 = 💕
GnuCash - GnuCash Double-Entry Accounting Program.
minion - :octopus: Perl high performance job queue
Tryton - Mirror of tryton
Octopussy - Octopussy - Open Source Log Management Solution
DOLIBARR ERP & CRM - Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
postgresqltuner - Simple script to analyse your PostgreSQL database configuration, and give tuning advice
django-ledger - A bookkeeping & financial analysis engine for the Django Framework.
apache2buddy - apache2buddy
metasfresh - We do Open Source ERP - Fast, Flexible & Free Software to scale your Business.