Probably once a month, I receive an email from a programmer who either wants to tune up their Oracle Database programming skills (SQL and PL/SQL, primarily) or wants to help me or the community in some way.
Here's the latest, via LinkedIn Messages:
I don't have a handy set of projects for people to work on, especially now that I am back with Oracle.
But there are plenty of opportunities for you out there, especially if you'd like to help build community tools. So here's a short list. I hope readers will offer others via the Comments section.
1. OraOpenSource - github.com/oraopensource
A project of oraopensource.com, led by Martin Giffy D'Souza, this repo offers an ever-growing set of utilities, with lots of room for expansion.
2. utPLSQL - github.com/utplsql
utPLSQL, which I originally built in 1999, is one of the most popular xUnit variants (JUnit, NUnit, etc.) for PL/SQL developers. It has recently moved to Github and is in the process of being revamped for a big V3 release. It's all written in PL/SQL!
3. oddGen - oddgen.org
oddgen is an Oracle SQL Developer extension to invoke dictionary-driven code generators.
4. Alexandria Library - https://github.com/mortenbra/alexandria-plsql-utils
This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere.
Two more great resources, though you have to come up with your own project ideas to use them:
1. I encourage you sign up for an apex.oracle.com workspace. You can then build your own websites using Oracle Application Express, using nothing but SQL, PL/SQL and some Javascript if you want to get fancy.
2. Use LiveSQL.oracle.com to play around with SQL and PL/SQL, as well as take advantage of an ever-growing library of scripts.
Here's the latest, via LinkedIn Messages:
I don't have a handy set of projects for people to work on, especially now that I am back with Oracle.
But there are plenty of opportunities for you out there, especially if you'd like to help build community tools. So here's a short list. I hope readers will offer others via the Comments section.
1. OraOpenSource - github.com/oraopensource
A project of oraopensource.com, led by Martin Giffy D'Souza, this repo offers an ever-growing set of utilities, with lots of room for expansion.
2. utPLSQL - github.com/utplsql
utPLSQL, which I originally built in 1999, is one of the most popular xUnit variants (JUnit, NUnit, etc.) for PL/SQL developers. It has recently moved to Github and is in the process of being revamped for a big V3 release. It's all written in PL/SQL!
3. oddGen - oddgen.org
oddgen is an Oracle SQL Developer extension to invoke dictionary-driven code generators.
4. Alexandria Library - https://github.com/mortenbra/alexandria-plsql-utils
This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere.
Two more great resources, though you have to come up with your own project ideas to use them:
1. I encourage you sign up for an apex.oracle.com workspace. You can then build your own websites using Oracle Application Express, using nothing but SQL, PL/SQL and some Javascript if you want to get fancy.
2. Use LiveSQL.oracle.com to play around with SQL and PL/SQL, as well as take advantage of an ever-growing library of scripts.
Thanks !
ReplyDelete