Open Source Financial Developers Association - Downloads

• Postgres

  • pg_ssl_init.zip 12.2.12: Generates self-signed server and client certificates+keys for pgadmin access via SSL. Contains the utility scripts "pg_ssl_init_server.py" and "pg_ssl_init_client.py".
  • dbical-postgres-instructions.pdf
  • dbiCal-simple.sql: No referential integrity enforcement for multi-purpose singly linked ids to one of a number of related tables. These multiply-purposed single ids are used in the tables "mtext" and "xprop", and are accomplished through use of a pair of columns that have the suffixes "..._ownertype" and "..._owner_id".
  • dbiCal.sql: Referential integrity enforcement for linked ids to one of a number of related tables, as used in the tables "xprop" and "mtext", with downlevel (application) compatibility support for multi-purpose single link ids implemented by means of triggers. Joins are high-performing at the cost of additional unique link id columns and indexes (storage and insert/update time) for each related owner id in each table. Newly developed applications can leverage off of these higher performing and more referentially validated tables.
  • dbiCal entity-relationship diagram for the iCalendar data model

• Elisp macros for Emacs

  • free-dictionary.el: An html parser that lets you do lookups in The Free Dictionary, directly from (text-mode) Emacs; this is a good illustration of static web parsing using Emacs. After loading the macro in your startup folder, you can move the point to a word and invoke the macro "free-dictionary". A split-screen should appear, with the definition of the word you were sitting on loaded into a lookup buffer. The macro may be re-invoked on another word in that lookup buffer.
  • display-all-buffers.el: A macro that opens multiple files passed on the command line as split screens.
    [The default behavior in GNU Emacs is to only open one file in a buffer, and offer a dired buffer to choose among others...]