The Ecto adapter landscape currently lacks an Oracle option, but you can use Postgres' foreign data wrapper feature to connect to a remote Oracle database. This posts will help you get oracle_fdw installed on newer versions of MacOS running SIP (System Integrity Protection).
A handful of examples of interacting with an Oracle data from Elixir via the erloci Erlang library.
Sandi Metz's Make Everything the Same post got me thinking about my own solution to the Roman Numerals kata and how it differed from so many others'
Get ~/.bash_profile changes to self-source.
A simple ssh configuration to transparently agent-forward through a bastion host.
A continued exploration of alternative techniques for making PeopleSoft effective date queries more readable and maintainable by composing subrelations and destructuring with the WITH clause.
How I ditched Evernote for markdown/vim with a tiny bash script for taking notes.
A join-based approach for speeding up PeopleSoft effective date queries and un-burdening your brain with WHERE clauses that are a mile long.
PeopleSoft tables don't use real primary keys—they use logical primary keys. So if you want to find the keys for say, the acad_prog_tbl table, one usually has to resort to venturing into the PeopleSoft web application (or worse, App Designer). If you want to save yourself this pain, you can query these keys from one of PeopleSoft's setup tables, pskeydefn.
It's always nice to know which version of your code is deployed. When your product owner discovers a bug in your staging/test instance especially, you want to know 'what version was that?'. Or, more importantly, 'who checked in and deployed that code?!'.
How to build a Clojure/Leiningen project that uses Oracle ojdbc6.jar without getting the dreaded `SQLException: No suitable driver found for jdbc:oracle:thin:...` error.
First, make a home for the new SSL files—I use /etc/apache2/ssl. Open up a terminal window, cd to the new directory and issue the following command to create a host key file.