I am wondering if there are examples of open source apps that are written in stored procedures? I read a lot about them in textbooks and would like to see how they are used in practice beyond implementing simple functionalities. One example that I found is the DBT benchmark implementations (http://sourceforge.net/apps/mediawiki/osdldbt) using stored procedures. If there are other similar applications I'd love to learn about them.

@a_horse_with_no_name: thanks for your pointer. Apps like LedgerSMB that makes heavy uses of stored procedures are exactly those that I am looking for. If there are other similar ones please let me know.

closed as too broad by Paul White, dezso, Mikael Eriksson, datagod, RLF Jan 27 '15 at 19:11

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


I doubt there are many applications that are completely written in stored procedures. Doing a (sophisticated) user interface based on a procedural language in a DBMS is pretty hard to do (depending on the DBMS maybe even impossible).

Oracle's APEX (APlication EXpress) is geared toward that, but the UI is still HTML - although it is generated generated through stored procedures if I'm not mistaken.

One application I know of that makes heavy use of stored procedures as part of the business logic is LedgerSMB: http://ledgersmb.org/

Not the answer you're looking for? Browse other questions tagged or ask your own question.