Die Welt ist meine Vorstellung

Clojure Database Access String

23 November 2020

此处放一些常用的数据库连接URL。使用时，替换 db_app, db_user, db_password

SQLite: 

{:database-url "jdbc:sqlite:db_app.db"}

MySQL1: 

{:database-url "jdbc:mysql://mysql.kimi.im:3306/db_app?useSSL=false&requireSSL=false&characterEncoding=utf8&serverTimezone=UTC&user=db_user&password=db_password"}

PostreSQL2: 

{:database-url "jdbc:postgresql://postgresql.kimi.im/db_app?user=db_user&password=db_password"}

Oracle3: 

{:database-url "jdbc:oracle:thin:db_user/db_password@//oracle.kimi.im:1521/db_app"}

SQLServer4: 

{:database-url "jdbc:sqserver://sqlserver.kimi.im:1433;databaseName=db_app;user=db_user;password=db_password;"}