This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2019-05-12
Channels
- # 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...
in postgresql you can actually define what you want to be returned 🙂
(it's just giving you more possible choices to make mistakes)
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?
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"
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 DBand 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.