This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
- # announcements (2)
- # aws (1)
- # beginners (63)
- # cider (2)
- # clj-kondo (1)
- # cljdoc (15)
- # clojure (114)
- # clojure-nl (1)
- # clojure-spec (15)
- # clojure-uk (10)
- # clojurescript (5)
- # clojutre (1)
- # community-development (6)
- # cursive (18)
- # data-science (1)
- # datascript (16)
- # datomic (2)
- # emacs (2)
- # events (3)
- # figwheel-main (2)
- # graphql (3)
- # jobs (2)
- # off-topic (23)
- # reitit (3)
- # shadow-cljs (27)
- # spacemacs (5)
- # sql (27)
- # unrepl (1)
-- :name insert-developer! -- :command :insert INSERT INTO DEVELOPERS (email) VALUES (:email);
@emccue The "last inserted ID" is different in pretty much every database. In MySQL it's
:GENERATED_KEY for example. PostgreSQL tends to return the entire row including the newly inserted key.
The various JDBC drivers often can't even be guaranteed to return keys rather than just update counts.
As the maintainer of
clojure.java.jdbc, this sort of crazy variability drives me crazy...
i think i should get a grip on that before doing a deeper dive into the more powerful sql databases
Note that SQLite has its own idiosyncrasies that can bite you. Though the fact that you don’t have to deal with user management is nice.
Anyone has encountered something like that before?
It happens with presto - doesn’t seem to be related to java.jdbc, but I guess you would encounter that when converting data from a DB
java.lang.IllegalAccessException: Class clojure.core$bean$fn__6906$fn__6907 can not access a member of class com.facebook.presto.jdbc.internal.client.FailureInfo$FailureException with modifiers "public"
and then maybe use reflection to make litterally everything about that class public so you can move on
the results of the TechEmpower single-query benchmark just finished with
porsas (part of the
reitit suite) entry. Here’s the list of Clojure Entries:
It’s already good, but I think there is room of improvement, might be just server & pool config. Fastest Java-version on Undertow is 410k.
But, I think I’ll move to support async-db-stuff with
porsas, to see how that matters. Starting with PostgreSQL.