blocks|key|28706|text|clojure-contrib有一个sql库，它是对JDBC+(java.sql.DriverManager)的一个薄包装器。它附带的测试文件有一些用法示例。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|28707|entityMap|0|LINK|mutability|MUTABLE|url|http://sourceforge.net/projects/clojure-contrib^0|0|F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://sourceforge.net/projects/clojure-contrib" rel="noreferrer">clojure-contrib</a> has an sql library which is a thin wrapper around JDBC (java.sql.DriverManager). The test file that comes with it has some examples of its usage.

blocks|key|4096137|text|我现在(截止到2011年末)推荐Korma+--+"Tasty+SQL+for+Clojure“|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4096138|这是一个漂亮的小SQL+DSL，下面是网站上的一个例子：|4096139|(select+users
++(aggregate+(count+:*)+:cnt)
++(where+(or+(>+:visits+20)
+++++++++++++(<+:last_login+a-year-ago))))|code-block|syntax|javascript|4096140|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlkorma.com/^0|G|5|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I would now (as of late 2011) recommend <a href="http://sqlkorma.com/" rel="noreferrer">Korma</a> - "Tasty SQL for Clojure"

It's a beautiful little SQL DSL, here's an example from the website:

<pre><code>(select users
 (aggregate (count :*) :cnt)
 (where (or (&gt; :visits 20)
 (&lt; :last_login a-year-ago))))
</code></pre>

blocks|key|3250720|text|如果您对使用Java库持开放态度，但又希望使用简单的库，那么您可能会喜欢Persist。你只需要10分钟就能看一眼，看看它是否符合你的需求。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3250721|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/rufiao/persist^0|10|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you are open to using a Java library but want something that embraces simplicity, perhaps you'll like <a href="https://github.com/rufiao/persist" rel="nofollow noreferrer">Persist</a>. It'll only take you 10 minutes to have a look and see if it fits your needs.

blocks|key|28901|text|我想添加一个截至2011年11月的答案，以方便来自谷歌的任何人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|28902|Clojure+1.3中当前的核心SQL+access库是clojure.java.jdbc。在此基础上构建了一些非常好的库，如ClojureQL和Korma。|offset|length|28903|entityMap|0|LINK|mutability|MUTABLE|url|http://clojureql.org/|1|http://sqlkorma.com/^0|0|1S|9|0|22|5|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]|$D|U|E|V|1|W]]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]|N|$5|I|J|K|A|$L|O]]]]

I'd like to add an as-of-Nov-2011 answer for the sake of anybody coming here from Google.

The current core SQL access library in Clojure 1.3 is clojure.java.jdbc. There are some very good libraries built on top of this like <a href="http://clojureql.org/">ClojureQL</a> and <a href="http://sqlkorma.com/">Korma</a>.

blocks|key|28995|text|最新也是最好的SQL数据库似乎是HoneySQL和Yesql。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|28996|HoneySQL是一种非常优雅的生成SQL查询的领域特定语言。有传言说它甚至可以修改语句以进行高度优化，请参阅2015年2月24日的clojure-group线程"Current+best-of-breed+JDBC+libraries?“。|style|BOLD|28997|Niels+van+Klaveren在上面提到的帖子中说：|28998|“基本上，It+HoneySQL生成SQL脚本来重新链接外键引用，以清除数据库中的重复项。它将一个包含(至少)一个from表、一个group-by和一个order-by子句的蜜表select查询作为一个基本定义，它们被认为是重复的，以及记录应该被保留的顺序。结合JDBC元数据，该查询将被有效地重写以生成：|CODE|28999|更新所有外键references|29000|Delete语句以删除所有重复的|unordered-list-item|29001|的临时替换语句，用于统一唯一索引，以防止外键引用发生冲突|29002|29003|29004|为了创建性能最好但仍然独立于数据库的SQL，我必须使用额外的子句来扩展honeysql，比如OVER和PARTITION+BY。我不会说它是轻而易举的，但似乎工作得很好。|29005|..。|29006|这将SQL减少到(有时)GB的脚本到大约100行SQL，并且在某些情况下，运行时间从19小时减少到1.5分钟。|29007|另一方面，Yesql的目标是完全简单。它定义了一些函数来加载参数化的.sql-files。|29008|它的网页提到了以下"USPs"：|29009|29010|没有语法上的意外。您的数据库并不遵守SQL标准--他们都不遵守--但是Yesql并不关心。你永远不会花时间去寻找“等同的性别语法”。您将永远不需要退回到支持function.|29011|Better编辑器的(raw-sql+"some('funky'::SYNTAX)")。您的编辑器可能已经有了很好的SQL支持。通过将SQL保持为SQL，您可以使用它。|29012|Team互操作性。您的DBA可以读写您在Clojure+project.|29013|Easier性能调优中使用的SQL。需要解释该查询计划吗？当你的查询是普通的SQL时，这要容易得多。|29014|查询重用。将相同的SQL文件放到其他项目中，因为它们只是普通的SQL。将它们作为子模块共享。|29015|29016|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/jkk/honeysql|1|https://github.com/krisajenkins/yesql|2|https://groups.google.com/forum/#!topic/clojure/SgqL_zDvPdw^0|G|8|0|P|5|1|0|0|8|2A|11|2|0|0|1L|4|1T|8|24|8|0|0|0|0|0|0|1A|4|1F|C|0|0|0|5|5|Y|4|0|0|0|0|A|X|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1T|8|@]|9|@$A|1U|B|1V|1|1W]|$A|1X|B|1Y|1|1Z]]|C|$]]|$1|D|3|E|5|6|7|20|8|@$A|21|B|22|F|G]]|9|@$A|23|B|24|1|25]]|C|$]]|$1|H|3|I|5|6|7|26|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|27|8|@$A|28|B|29|F|L]|$A|2A|B|2B|F|L]|$A|2C|B|2D|F|L]]|9|@]|C|$]]|$1|M|3|N|5|6|7|2E|8|@]|9|@]|C|$]]|$1|O|3|P|5|Q|7|2F|8|@]|9|@]|C|$]]|$1|R|3|S|5|Q|7|2G|8|@]|9|@]|C|$]]|$1|T|3|-4|5|6|7|2H|8|@]|9|@]|C|$]]|$1|U|3|-4|5|6|7|2I|8|@]|9|@]|C|$]]|$1|V|3|W|5|6|7|2J|8|@$A|2K|B|2L|F|L]|$A|2M|B|2N|F|L]]|9|@]|C|$]]|$1|X|3|Y|5|6|7|2O|8|@]|9|@]|C|$]]|$1|Z|3|10|5|6|7|2P|8|@]|9|@]|C|$]]|$1|11|3|12|5|6|7|2Q|8|@$A|2R|B|2S|F|G]|$A|2T|B|2U|F|L]]|9|@]|C|$]]|$1|13|3|14|5|6|7|2V|8|@]|9|@]|C|$]]|$1|15|3|-4|5|6|7|2W|8|@]|9|@]|C|$]]|$1|16|3|17|5|Q|7|2X|8|@]|9|@]|C|$]]|$1|18|3|19|5|Q|7|2Y|8|@$A|2Z|B|30|F|L]]|9|@]|C|$]]|$1|1A|3|1B|5|Q|7|31|8|@]|9|@]|C|$]]|$1|1C|3|1D|5|Q|7|32|8|@]|9|@]|C|$]]|$1|1E|3|1F|5|Q|7|33|8|@]|9|@]|C|$]]|$1|1G|3|-4|5|6|7|34|8|@]|9|@]|C|$]]|$1|1H|3|-4|5|6|7|35|8|@]|9|@]|C|$]]]|1I|$1J|$5|1K|1L|1M|C|$1N|1O]]|1P|$5|1K|1L|1M|C|$1N|1Q]]|1R|$5|1K|1L|1M|C|$1N|1S]]]]

The latest and greatest for SQL databases seems to be <a href="https://github.com/jkk/honeysql">HoneySQL</a> and <a href="https://github.com/krisajenkins/yesql">Yesql</a>.

HoneySQL is a quite elegant DSL to generate SQL queries. There are rumours it can even modify the statements to be highly optimized, see the clojure-group thread "<a href="https://groups.google.com/forum/#!topic/clojure/SgqL_zDvPdw">Current best-of-breed JDBC libraries?</a>" from Feb 24 2015.

Niels van Klaveren says in the above-mentioned thread:

"Basically, it [HoneySQL] generates SQL scripts to relink foreign key references to clean up duplicates in a database. It takes a honeysql select query with (at least) a <code>from</code> table, a <code>group-by</code> and an <code>order-by</code> clause as a base definition what are to be considered doubles, and in which order records should be preserved. In combination with JDBC metadata that query effectively gets rewritten to generate:

<ul>
<li>A temporary replacement table</li>
<li>Queries to unify unique indexes, to prevent clashes when foreign key references are updated</li>
<li>Queries to update all foreign key references</li>
<li>Delete statements to remove all duplicates</li>
</ul>

To create the best performing, but still database independent SQL, I had to extend honeysql with extra clauses like <code>OVER</code> and <code>PARTITION BY</code>. I wouldn't say it was a breeze, but seemed to work very well.

...

That cut down SQL to (sometimes) GB's of script to around a few 100 lines of SQL, and on one occasion, a runtime from 19 hours to 1.5 minutes."

Yesql, on the other hand, aim for total simplicity. It defines some functions to load parameterized <code>.sql</code>-files.

It's webpage mentions the following "USPs":

<ul>
<li>No syntactic surprises. Your database doesn't stick to the SQL standard - none of them do - but Yesql doesn't care. You will never spend time hunting for "the equivalent sexp syntax". You will never need to fall back to a <code>(raw-sql "some('funky'::SYNTAX)")</code> function.</li>
<li>Better editor support. Your editor probably already has great SQL support. By keeping the SQL as SQL, you get to use it.</li>
<li>Team interoperability. Your DBAs can read and write the SQL you use in your Clojure project.</li>
<li>Easier performance tuning. Need to EXPLAIN that query plan? It's much easier when your query is ordinary SQL.</li>
<li>Query reuse. Drop the same SQL files into other projects, because they're just plain ol' SQL. Share them as a submodule.</li>
</ul>

blocks|key|28764|text|我在Clojure中将Berkeley+DB用于一个简单的键/值数据库。参见here。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|28765|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technology/products/berkeley-db/je/index.html|1|http://github.com/schani/flickr-clojure/blob/3a65b232bc95221f799b57a20c2b5f60f5b13aca/at/ac/tuwien/complang/persistence_bdb.clj^0|B|B|0|12|4|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

I've used <a href="http://www.oracle.com/technology/products/berkeley-db/je/index.html" rel="noreferrer">Berkeley DB</a> for a simple key/value database in Clojure. See <a href="http://github.com/schani/flickr-clojure/blob/3a65b232bc95221f799b57a20c2b5f60f5b13aca/at/ac/tuwien/complang/persistence_bdb.clj" rel="noreferrer">here</a>.

blocks|key|3250788|text|有一个包含关系代数的ClojureQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3250789|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/LauJensen/clojureql^0|A|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

There's <a href="https://github.com/LauJensen/clojureql" rel="nofollow">ClojureQL</a> which embraces relational algebra.

blocks|key|878062|text|现在有Datomic和许多类似的解决方案，如DataScript，用于非常有趣的关系(非sql！)数据库功能也是如此。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|878063|entityMap|0|LINK|mutability|MUTABLE|url|http://www.datomic.com/|1|https://github.com/tonsky/datascript^0|3|7|0|M|A|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Nowadays there are <a href="http://www.datomic.com/" rel="nofollow">Datomic</a> and many similar solutions like <a href="https://github.com/tonsky/datascript" rel="nofollow">DataScript</a> for very interesting relational (non-sql!) database capabilities as well.

blocks|key|883092|text|如果您需要持久连接和/或到多个数据库的连接，并且不想频繁地重新建立连接，我建议您使用DB连接池。像BoneCP或Tomcat之类的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|883093|您可以将这些包中的连接提供给(clojure.contri.sql/+DataSources+-connection+...)。|883094|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you need persistent connections and/or connections to multiple databases and do not want to reestablish connections every so often I would recommend using DB connection pools. Something like BoneCP or Tomcat CP.

You can supply DataSources from those packages to (clojure.contrib.sql/with-connection ...).

blocks|key|3250968|text|然后是SQLLite。看一下这个简单的例子：https://github.com/ogrim/clojure-sqlite-example|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3250969|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/ogrim/clojure-sqlite-example^0|M|1B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Then there is SQLLite. Have a look at this simple example: <a href="https://github.com/ogrim/clojure-sqlite-example" rel="nofollow">https://github.com/ogrim/clojure-sqlite-example</a>

blocks|key|3251025|text|首先，导入库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3251026|+(ns+clojureexercise.test
++++(:require+[clojure.java.jdbc+:as+sql]))+;;sql+will+alias+used+further+in+code+to+access+java+jdbc+feature.|code-block|syntax|javascript|3251027|其次，下面的功能可以让你连接MySQL服务器。像在Java中一样，我们声明数据库变量来启动DB，这里的方法与我们定义数据库连接的方式相同，在下面的代码中，您可以看到在dbconnect函数中定义了db变量。db变量将在运行查询时进一步使用。|3251028|(defn+dbconnect+[]
++(def+db{+++
+++++++++:classname+"com.mysql.jdbc.Driver"+
+++++++++:subprotocol+"mysql"
+++++++++:subname+"//127.0.0.1:3306/testdb"+;;testdb+is+the+name+of+database
+++++++++:user+"root"
+++++++++:password+"password"}))|3251029|现在,|3251030|;;Inserting+Data+into+Database+
;;Table+Name+is+patientinfo,+consist+columns+{id,+firstname,+lastname,+birthdate,+gender}
+(defn+insertdata+[]
++(sql/insert!+db+:patientinfo++++++++++++++++++++;;used+sql+alias+and+db+variable+to+insert+data+into+table+
++{:id+1+:firstname+"Satyam"+:lastname+"Ramawat"+
+++:birthdate+"1/1/2018"+:gender+"Male"+}))|3251031|我将更详细地阐述这一点：|3251032|3251033|+sql/insert！db+:patientinfo|blockquote|offset|length|style|BOLD|3251034|3251035|3251036|sql将启用插入查询功能，而db将允许系统了解记录必须插入到哪个数据库连接的哪个表上。|3251037|entityMap^0|0|0|0|0|0|0|0|0|1|Q|0|0|0|0|3|E|2|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1C|8|@$U|1D|V|1E|W|X]]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1H|8|@$U|1I|V|1J|W|X]|$U|1K|V|1L|W|X]]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|13|$]]

Firstly, Import libraries from 

<pre><code> (ns clojureexercise.test
 (:require [clojure.java.jdbc :as sql])) ;;sql will alias used further in code to access java jdbc feature.
</code></pre>

Secondly, the function below allows you to connect MySQL server. Like in Java, we declare Database variable to start DB, here it is the same way we have to define Database connectivity and in below code you can see db variable is defined in the dbconnect function. db variable will be used further in running queries.

<pre><code>(defn dbconnect []
 (def db{ 
 :classname "com.mysql.jdbc.Driver" 
 :subprotocol "mysql"
 :subname "//127.0.0.1:3306/testdb" ;;testdb is the name of database
 :user "root"
 :password "password"}))
</code></pre>

Now,

<pre><code>;;Inserting Data into Database 
;;Table Name is patientinfo, consist columns {id, firstname, lastname, birthdate, gender}
 (defn insertdata []
 (sql/insert! db :patientinfo ;;used sql alias and db variable to insert data into table 
 {:id 1 :firstname "Satyam" :lastname "Ramawat" 
 :birthdate "1/1/2018" :gender "Male" }))
</code></pre>

I will elaborate this more:

<blockquote>
 sql/insert! db :patientinfo
</blockquote>

sql will enable insert query functionality and db will allow the system to understand on which table the record has to be inserted of which database connection.

blocks|key|883107|text|你也可以尝试CLJ-Record，https://github.com/duelinmarkers/clj-record|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|883108|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/duelinmarkers/clj-record^0|H|17|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You could also try CLJ-Record, <a href="https://github.com/duelinmarkers/clj-record" rel="nofollow">https://github.com/duelinmarkers/clj-record</a>

What methods to use a database from Clojure are there?

I know from Clojure you can do anything you can with Java, but that means that I may end up using something overly complicated (like Hibernate) which clashes with Clojure simplicity. Any recommendations or comments?

Use a database with Clojure

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

使用Clojure中的数据库有哪些方法？我从Clojure中知道你可以用Java做任何事情，但这意味着我最终可能会使用一些过于复杂的东西(比如Hibernate)，这与Clojure的简单性相冲突。有什么建议或意见吗？

问在Clojure中使用数据库
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Clojure中使用数据库EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Clojure中使用数据库
EN