Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

put on hold as too broad by Paul White, dezso, Mikael Eriksson, datagod, RLF 14 hours ago

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

up vote 2 down vote accepted

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/

share|improve this answer

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