LWN.net Logo

Accounting systems: Grow your own?

Accounting systems: Grow your own?

Posted May 9, 2012 1:00 UTC (Wed) by drh (subscriber, #65025)
Parent article: Accounting systems: a rant and a quest

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.


(Log in to post comments)

Accounting systems: Grow your own?

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.

Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds