Dear community,
Meikel and I have been driving an effort to get ClojureQL to version
1.0.
For those who do not yet know about ClojureQL, its a database adapter
which allows you to interface with MySql, Derby, Sqlite etc, without
ever leaving your lisp syntax. But more than being a syntax thing,
ClojureQL also is able to extend the functionality of databases, ie.
you can currently find an emulator in the backend which enables both
MySql and Derby to do FULL joins - Not something you normally get to
do.
In terms of functionality we almost cover every need that you'll have
when working with SQL, but there are still quirks to be ironed out
(ex. joins) and features to be added and extended (ex. alter table).
But this is where we'd like to appeal to the community to hit us with
some feedback! If you're interested in Clojure/SQL and you can find
the time to experiment a little, its as simple as this.
1) Put the src/ or the jar file on your class-path and get a REPL
going.
2) user> (use 'dk.bestinclass.clojureql) // Import the functions
3) Have fun, ala:
user> (def *connection* (make-connection-info "mysql" "//localhost/
cql" "cql" "cql"))
#'user/*connection*
user> (load-driver "com.mysql.jdbc.Driver")
com.mysql.jdbc.Driver
user> (run [*connection* results] (query * test)
(take 3 results))
({:id 1, :age 224} {:id 2, :age 23} {:id 3, :age 402})
If you run into trouble, because somethings is not currently
implemented, you can always resort to using (raw "SELECT * FROM foo
USING SPECIAL FUNC") or something similar - So you wont be stuck. If
you come across some features that are lacking, bugs that need
reporting or similar, please drop us a message at IRC or Github,
you'll find the project here: http://github.com/Lau-of-DK/clojureql/tree/master
Expect Join/Run syntax to change in the near future, and dont be
surprised if you come across something that needs a patch - We're not
1.0 yet, and we could use a little help in getting there :)
/Lau
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
-~----------~----~----~----~------~----~------~--~---
