The accounting needs of SQLite.org are likely much simpler than those of LWN.net. Nevertheless, it seems worth mentioning that we've gotten along fine here since 1995 using a database with a very simple schema and a handful of CGI scripts written in TCL. This system keeps track of client contact information, invoicing, various bank accounts, payroll and expenses, and then it generates a general ledger, income statement, and balance sheet which we print out and take to our accountant once a year at tax time. The key descriptor of the system is "simple". There are no graphics. Just some <form> and <table> elements mixed with a few SQL statements. The whole thing took about one day to hack together nearly two decades ago, and apart from minor adjustments now and then (ex: conversion from PostgreSQL to SQLite sometime around 2002) it has served us well with a minimum of fuss.
Beware of "shiny". And do not underestimate the power of CGI + scripting language + SQL.
Posted May 9, 2012 2:24 UTC (Wed) by piggy (subscriber, #18693)
[Link]
Riffing on this theme, why not throw together a small pool of money and hire someone to deliver the system you need? Publish the result and voila! Scratch a personal itch doesn't have to mean you code it yourself.
Accounting systems: Grow your own?
Posted May 17, 2012 9:09 UTC (Thu) by kragil (subscriber, #34373)
[Link]
Good idea, but who is doing the Kickstarter or Indiegogo for it?
Accounting systems: Grow your own?
Posted May 12, 2012 9:40 UTC (Sat) by juliank (subscriber, #45896)
[Link]
Or you just need to get Linus have to do some accounting; I'm sure he'll write a software then.