Databases
StackOverflow2013
Postsdbo
PODatabase Functional Programming in Clojure
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase Functional Programming in Clojure
    primarykey
    data
    text
    <p><em>"It is tempting, if the only tool you have is a hammer, to treat everything as if it were a nail."</em> - Abraham Maslow</p> <p>I need to write a tool to dump a large hierarchical (SQL) database to XML. The hierarchy consists of a <code>Person</code> table with subsidiary <code>Address</code>, <code>Phone</code>, etc. tables.</p> <ul> <li><p>I have to dump <em>thousands</em> of rows, so I would like to do so incrementally and not keep the whole XML file in memory.</p></li> <li><p>I would like to isolate non-pure function code to a small portion of the application.</p></li> <li><p>I am thinking that this might be a good opportunity to explore FP and concurrency in Clojure. I can also show the benefits of immutable data and multi-core utilization to my skeptical co-workers.</p></li> </ul> <p>I'm not sure how the overall architecture of the application should be. I am thinking that I can use an impure function to retrieve the database rows and return a lazy sequence that can then be processed by a pure function that returns an XML fragment.</p> <p>For each <code>Person</code> row, I can create a <code>Future</code> and have several processed in parallel (the output order does not matter).</p> <p>As each <code>Person</code> is processed, the task will retrieve the appropriate rows from the <code>Address</code>, <code>Phone</code>, etc. tables and generate the nested XML.</p> <p>I can use a a generic function to process most of the tables, relying on database meta-data to get the column information, with special functions for the few tables that need custom processing. These functions could be listed in a <code>map(table name -&gt; function)</code>.</p> <p>Am I going about this in the right way? I can easily fall back to doing it in OO using Java, but that would be no fun.</p> <p>BTW, are there any good books on FP patterns or architecture? I have several good books on Clojure, Scala, and F#, but although each covers the language well, none look at the "big picture" of function programming design.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USRalph
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODatabase Functional Programming in Clojure
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODatabase Functional Programming in Clojure
      1. USG__
      1. VTFavorite
    3. VO
      singulars
      1. PODatabase Functional Programming in Clojure
      1. USDaniel
      1. VTFavorite
    1. COTo my knowledge there isn't an "FP for architects" book. However, if you read "Purely Functional Data Structures" end to end, you'll definitely get a better idea of how to apply FP concepts in the real world. See http://www.amazon.com/Purely-Functional-Structures-Chris-Okasaki/dp/0521663504
      singulars
      1. PODatabase Functional Programming in Clojure
      1. USChris Smith
    2. CO@Chris Smith: I have that one on my Amazon wish list. I'll check it out.
      singulars
      1. PODatabase Functional Programming in Clojure
      1. USRalph
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload