Commit graph

336 commits

Author SHA1 Message Date
Sean Corfield
91dda2cdae Document stateful transduce issues: Fixes #149 2021-03-24 23:45:54 -07:00
Sean Corfield
1edba5079a Minor library version updates 2021-03-21 11:55:43 -07:00
Sean Corfield
1d3fd03ae8 Wordsmithing 2021-03-18 14:17:28 -07:00
Sean Corfield
c0c2522e28 Add example JDBC drivers/versions 2021-03-18 14:15:54 -07:00
Sean Corfield
00a6a4561b Prep for 1.1.646 release 2021-03-15 17:13:34 -07:00
Sean Corfield
7e13e719ce Fixes #161 by adding batch execution for connectable/SQL 2021-03-15 15:16:59 -07:00
Sean Corfield
c7881fe078 Prep for 1.1.643; switch to com.github.seancorfield 2021-03-06 15:15:41 -08:00
Sean Corfield
dd62b5fcff Fixes #158 by documenting allowMultiQueries for MySQL 2021-03-06 15:01:05 -08:00
Sean Corfield
abc4d22302 Document next.jdbc.transaction/*nested-tx* fully 2021-03-06 14:28:47 -08:00
Simon Robson
10d6925efd Typos 2021-02-15 11:49:43 +07:00
Kimmo Koskinen
e956428ac4
Add rs/ alias to clob->string example 2021-02-01 19:03:16 +02:00
Sean Corfield
a1e51bf007 Fix #157 by adding next.jdbc/execute-batch!
This breaks the circular dependency completely.
`next.jdbc.prepare/execute-batch!` is deprecated.
2021-01-30 16:36:05 -08:00
Sean Corfield
8d3758b5aa Minor version/tooling updates 2021-01-29 13:16:46 -08:00
Lauri Oherd
1ed8bfcebd fix some typos 2021-01-05 14:08:40 +02:00
alexandrkozyrev
4bd71d96c9
Update friendly-sql-functions.md 2020-12-16 14:47:15 +03:00
Sean Corfield
5737495c4e Fixes #144; prep for 1.1.613 release 2020-11-05 12:47:21 -08:00
Sean Corfield
3a30e22840 Clarify Clojure 1.10 is a minimum requirement 2020-11-03 09:46:25 -08:00
Sean Corfield
347ad43f0b Prep for 1.1.610 release 2020-10-19 11:17:07 -07:00
Sean Corfield
ef96e04cb6 Add note to with-options to see usage examples/caveats below 2020-09-20 11:43:43 -07:00
Sean Corfield
84fe3ea1af Add nil guard to PG JSON example 2020-09-15 22:46:35 -07:00
Sean Corfield
d042939424 Prep for 1.1.588 2020-09-09 13:11:50 -07:00
Sean Corfield
fdeea5c0e9 Fixes #139 by adding select! and select-one! 2020-09-09 12:29:33 -07:00
Sean Corfield
e9c75a7afd Prep 1.1.582 -- fixes #138 2020-08-05 18:18:30 -07:00
Sean Corfield
4a96165b0b Prep for 1.1.581 release 2020-08-03 18:15:56 -07:00
Sean Corfield
0fcbfcdc74 Add BOOLEAN to SQLite Tips & Tricks example for #134 2020-07-22 16:55:44 -07:00
Sean Corfield
0af209c862 Add plan example for SQLite bool/bit transform 2020-07-22 16:27:36 -07:00
Sean Corfield
c2a18bfea6 Address #134 by documenting builder-adapter workaround for SQLite 2020-07-22 16:23:39 -07:00
Sean Corfield
734c4bfada Fixes #133 by adding :return-generated-keys to execute-batch! 2020-07-22 13:01:51 -07:00
Sean Corfield
3143cd1acd Clean up example of default options and tx 2020-07-20 12:51:08 -07:00
Sean Corfield
32e03ad80f Prep for 1.1.569 release 2020-07-10 22:57:41 -07:00
Sean Corfield
7e8555a2b3 Improve ReadableColumn extension docs
Note that extension via metadata is possible.
2020-07-08 23:11:21 -07:00
Sean Corfield
8f1ba70d8c Document #121 in result set builders 2020-07-08 23:06:44 -07:00
Sean Corfield
d7adfc9d5c Document #121 in friendly SQL functions 2020-07-08 23:03:14 -07:00
Sean Corfield
b56bd27702 Add metadata plan function 2020-07-08 23:02:59 -07:00
Sean Corfield
574280dc1d Explain row realization in more detail 2020-07-08 22:55:50 -07:00
Sean Corfield
e750f20df8 Document #121 for new, optional builders 2020-07-08 22:55:29 -07:00
Sean Corfield
531fb702ad Fix typo 2020-07-08 22:55:06 -07:00
Sean Corfield
37f167eed1 Explain dependence on :cols and :rsmeta in builders 2020-07-07 14:30:27 -07:00
Sean Corfield
8a8a0b2122 Fixes #129 by adding builder-adapter and with-column-value 2020-07-07 14:19:12 -07:00
Sean Corfield
71ea50eff8 Clarify get-by-id example per Vincent Cantin 2020-07-02 09:39:23 -07:00
Sean Corfield
cacb4bdb4a Various documentation updates!
Fixes `:rewriteBatchedStatement`(`s`) for MySQL!
2020-06-30 12:31:28 -07:00
Sean Corfield
7ff03231b8 Clarify combining strategy 2020-06-29 18:22:34 -07:00
Sean Corfield
150acbfb51 Prep for 1.1.547 2020-06-29 14:03:48 -07:00
Sean Corfield
c09d72f187 Fixes #116 by documenting multiple result sets 2020-06-27 16:10:23 -07:00
Sean Corfield
77ebb31026 Interleave combine with batch reductions #125 2020-06-26 22:21:49 -07:00
Sean Corfield
68d8f98d26 Document folding over plan #125 2020-06-26 21:31:43 -07:00
Sean Corfield
a4a8602af4 Add examples of :columns usage 2020-06-25 13:09:38 -07:00
Sean Corfield
3c4638a269 Support :columns option to filter results in find/get 2020-06-25 12:48:22 -07:00
Sean Corfield
036ed0deba Add example of find :all with pagination 2020-06-24 22:56:06 -07:00
Sean Corfield
7dfcb9f9f6 Document #124 pagination and find :all 2020-06-24 22:48:45 -07:00
Sean Corfield
26b8fa1600 Fixes #124 by supporting pagination
Support `:all` in `find-by-keys`. Document all these options. Update the 
specs.
2020-06-24 19:27:32 -07:00
Sean Corfield
2e1e11c025 Prep for 1.0.478 release 2020-06-24 11:26:14 -07:00
Sean Corfield
03792303bc Fixes #123 by adding type-hinting functions 2020-06-24 11:23:40 -07:00
Sean Corfield
85734ab724 Prep for 1.0.476
Extend default options behavior to `next.jdbc.sql` functions.
2020-06-22 23:16:05 -07:00
Sean Corfield
ffc15fb1f6 Prep for 1.0.475 release 2020-06-22 16:43:51 -07:00
Sean Corfield
b9b77bb40f Fixes #122 by adding next.jdbc/with-options 2020-06-22 16:38:13 -07:00
Sean Corfield
467a0517bb Remove {} from coord to make it easier to copy'n'paste 2020-06-18 13:03:38 -07:00
Sean Corfield
aec0693b14 Default SQL Server DB is model
Also update branch references.
2020-06-16 11:28:27 -07:00
Sean Corfield
509e065fbf Fixes #115 by providing do-commands example 2020-06-07 10:01:12 -07:00
Sean Corfield
6d362ab611 Prep for 1.0.462 release 2020-05-31 21:41:44 -07:00
Sean Corfield
768ba3ac44 Note impact of datafication on result set metadata function 2020-05-31 21:37:12 -07:00
Sean Corfield
cc3988e773 Document all the new datafy/nav stuff 2020-05-31 21:32:03 -07:00
Sean Corfield
8f6844aa5d Fix typo in example 2020-05-25 11:36:23 -07:00
Sean Corfield
7bbc626950 Prep for 1.0.445 release 2020-05-23 09:43:07 -07:00
Sean Corfield
91b1b25475 Fixes #110 by documenting the solution
In addition to adding `row-number` and `column-names`, this also adds 
support for associative access by numeric key and indexed access.
2020-05-23 00:01:39 -07:00
Sean Corfield
e855246ff3 Add example of execute-batch! with :return-keys 2020-05-20 15:07:15 -07:00
Maxim Penzin
63331e3742 link to jdbc docs 2020-05-08 12:32:21 +08:00
Maxim Penzin
87d051fb56 link to jdbc docs 2020-05-08 12:31:05 +08:00
Maxim Penzin
6604692886 tips-and-tricks: SQL Array as Clojure vector example 2020-05-08 12:19:58 +08:00
Maxim Penzin
8d8c7efebb Parameter type hint in tips-and-tricks 2020-05-08 10:40:53 +08:00
Sean Corfield
900703a32a Add component usage to Getting Started 2020-04-29 19:28:59 -07:00
Sean Corfield
aa1c8a4cea Add MySQL-specific streaming tip 2020-04-27 17:48:29 -07:00
Sean Corfield
d3f126145b Reword :fetch-size description
The "zero or negative" wording dates back to `clojure.java.jdbc` and was 
a bit misleading.
2020-04-22 12:41:15 -07:00
Sean Corfield
300681bb78 Prep for 1.0.424 2020-04-10 14:36:34 -07:00
Sean Corfield
90aed503bd More timeout tidying up 2020-04-10 12:50:13 -07:00
Sean Corfield
a3e7b01187 Fixes #103 by documenting timeouts 2020-04-10 12:45:34 -07:00
Sean Corfield
f70d93b156 Surface database metadata handling in Getting Started 2020-04-10 12:07:08 -07:00
Sean Corfield
2fd27d18bd Improve documentation around next.jdbc.date-time
Expands the documentation around each place it is referenced. Expands 
the namespace docstring. Adds a mention of it to the result-set 
namespace docstring.
2020-04-07 14:29:37 -07:00
Sean Corfield
bf6de1d8da Merge branch 'master' of github.com:seancorfield/next-jdbc 2020-04-07 13:45:40 -07:00
Sean Corfield
74ce12c5c0 Remove bogus type hints
Not sure how/why these ended up in the docs but they are wrong/not 
needed.
2020-04-07 13:45:22 -07:00
Jakub Holy
e36e94c020
Clarify timeout is in ms 2020-04-06 12:55:31 +02:00
Sean Corfield
2574e7e37f Note MySQL handling of BLOB 2020-03-31 11:58:45 -07:00
Sean Corfield
90da9d16a6 Prep for 1.0.409 release 2020-03-16 15:28:44 -07:00
Sean Corfield
780c759541 Complete support for MariaDB #100
Adds tests and test dependencies, based on a new environment variable. 
Updates change log. Documents difference in generated key return between 
MySQL and MariaDB.
2020-03-16 15:19:21 -07:00
Sean Corfield
930b5f0384 Prep for 1.0.405 (documentation) 2020-03-14 16:17:17 -07:00
Sean Corfield
ca37ed5106 Remove extra paren from JSON support code 2020-03-09 11:06:56 -07:00
Sean Corfield
79236b45e5 Improve plan/reduce documentation
Also rolls H2 version back so examples work properly. 1.4.200 doesn't 
like one of the data types the examples use.
2020-03-08 17:05:13 -07:00
Sean Corfield
db993e0d30 Release 1.0.395 2020-03-02 13:49:11 -08:00
Sean Corfield
85da329bde Prepare for 1.0.next release
Should be 1.0.395
2020-03-02 13:48:19 -08:00
Sean Corfield
3d10e9bdd9 Add mention of next.jdbc.date-time to PostgreSQL Tips & Tricks 2020-03-01 10:14:28 -08:00
Sean Corfield
051bc9bd9c Fixes #95 by adding notes about/links to next.jdbc.date-time 2020-03-01 10:11:18 -08:00
Sean Corfield
11f03de1f5 Add Tips & Tricks to doc index 2020-02-28 13:26:40 -08:00
Sean Corfield
4d7940a5d3 Reorganize Tips & Tricks after #94 2020-02-28 13:23:06 -08:00
Valtteri Harmainen
32a6b30035 Add docs for working with postgres json and jsonb 2020-02-28 22:53:22 +02:00
Sean Corfield
4ab0ecd7df Prep for 1.0.384 release 2020-02-28 11:04:11 -08:00
Sean Corfield
eb722b502e Fixes #93 by improving documentation about datafiable-row 2020-02-28 10:54:28 -08:00
Sean Corfield
81743f1484 Address #92 by repeating transaction/connection note 2020-02-26 11:56:08 -08:00
Sean Corfield
126ac58c34 Fixes #88 by calling 1-arity keyword
Also supports calling `:qualifier-fn` on an empty table name.
2020-02-26 11:48:42 -08:00
Sean Corfield
8083689821 Note PG returns entire row 2020-02-20 07:21:17 -08:00
Sean Corfield
789bf1fae6 Added streaming options for PostgreSQL to Tips & Tricks 2020-02-12 12:43:57 -08:00
Sean Corfield
9f7a3f5906 Apply #85 to the migration guide too 2020-01-17 10:44:59 -08:00
bpringe
7357a913a2
Correct "suffices" to "suffixes" 2020-01-17 10:23:46 -08:00
Sean Corfield
f66a68d294 Prep for 1.0.13 release 2019-12-29 16:14:32 -08:00
Sean Corfield
79d2772e14 Attempt to clarify when prepared statements are created 2019-12-25 21:16:24 -08:00
Sean Corfield
a2ba8ff780 Fixes #82 and adds next.jdbc.prepare/statement 2019-12-20 15:45:22 -08:00
Sean Corfield
bcde88e1ee Prep for 1.0.12 2019-12-11 16:46:42 -08:00
Sean Corfield
6497641896 Fixes #78 by documenting the workaround
Getting Started's notes about HikariCP now link to the issue on that 
repo.
2019-12-11 14:45:54 -08:00
Sean Corfield
986c37c457 Prep for 1.0.11 release 2019-12-07 09:21:18 -08:00
Sean Corfield
c7e2e61bb6 Make "notes" consistent in formatting 2019-11-26 11:12:37 -08:00
Sean Corfield
fec1166e5c Test on JDK11; document updated Derby versions
1.15.x.y requires JDK9+ and requires two dependencies.

1.14.x.y runs on JDKs up to 11.
2019-11-16 00:12:13 -08:00
Sean Corfield
ce3530233f Fix Tips & Tricks link 2019-11-14 19:22:43 -08:00
Sean Corfield
05a6d8a47f Prep for 1.0.10 release 2019-11-14 19:08:50 -08:00
Sean Corfield
d561a7108e Fixes #75 by adding java.sql.Statement support 2019-11-14 16:15:52 -08:00
Sean Corfield
5e52d30927 Improve docs for column name conflicts 2019-11-13 10:04:52 -08:00
Sean Corfield
6450bfa0f2 Clarify :result-type/:concurrency interaction
Also further clarify MS SQL Server behavior.
2019-11-13 09:52:32 -08:00
Sean Corfield
e81f382ef8 Add MS SQL Server to Tips & Tricks 2019-11-13 09:37:21 -08:00
Sean Corfield
ce00025c3d Doc cleanup 2019-11-10 14:24:39 -08:00
Sean Corfield
f864cd67cd Make option handling more obvious; show :builder-fn 2019-11-10 13:47:08 -08:00
Sean Corfield
e2058fb6ae Further caveat on unqualified column names 2019-11-08 11:16:17 -08:00
Sean Corfield
bb3048f8f8 More documentation improvements 2019-11-08 11:12:17 -08:00
Sean Corfield
be416fee81 Add simplicity caveat to friendly SQL functions
Also provide more detail about alternatives.
2019-11-08 10:42:18 -08:00
Sean Corfield
b5048cca85 Improve migration docs
`next.jdbc.connection` namespace docstring now mentions `dbtypes` and 
`->pool`. **Primary API** in the migration doc now explicitly recommends 
using a datasource for piecemeal migration.
2019-11-08 10:20:28 -08:00
Sean Corfield
dd70625e8f Clarify behavior when no rows match a query 2019-11-01 09:34:14 -07:00
Sean Corfield
ea0f1868b3 More documentation for #70
Adds CLOB & BLOB SQL Types to Tips & Tricks section with example of 
`ReadableColumn` extension and reference to helper/column reader in 
`next.jdbc.result-set`.
2019-10-17 18:02:37 -07:00
Lauri Oherd
5f1d081af9
fix link
fix link to all-the-options.md file
2019-10-17 16:18:21 +03:00
Sean Corfield
61083eba69 Address #70 by adding/documenting CLOB column reader example 2019-10-14 11:13:36 -07:00
Sean Corfield
bde9c2d074 Prep for 1.0.9 release 2019-10-11 11:35:46 -07:00
Sean Corfield
8c75e3a546 Addresses #69 by expanding docs for execute-one!
Updates include adding notes on `execute!`, `execute-one!`, and `plan` 
in the README, as well as expanding the docstrings for those functions.
2019-10-11 11:26:41 -07:00
Sean Corfield
222449c9a9 Fixes #68 by clarifying docs around :next.jdbc/update-count 2019-10-01 10:53:23 -07:00
Sean Corfield
0e4c6b8d6f Prep for 1.0.8 2019-09-27 19:59:20 -07:00
Sean Corfield
6c42d7ce67 Fixes #66 by adding support for :jdbcUrl in db-spec hash map 2019-09-27 13:06:45 -07:00
Sean Corfield
0f0f6fbe92 Add "latest versions" caveat 2019-09-27 13:06:05 -07:00
Sean Corfield
d17222e031 Fixes #65 by adding HugSQL docs 2019-09-27 12:20:02 -07:00
Sean Corfield
8cb05f4495 Fix #63 by adding caveats to qualified column name docs 2019-09-14 18:13:39 -07:00
Sean Corfield
e03de7828a Document PR #64
Add to change log, Getting Started, and ns docstring for 
`next.jdbc.specs`. Also note docs in GitHub are for **master** now.
2019-09-14 13:32:34 -07:00
Sean Corfield
3dfc6ffba2 Prep for 1.0.7 release 2019-09-09 16:29:49 -07:00
Sean Corfield
2c51c549d6 Fixes #60 by documenting/testing simpler :schema format 2019-09-09 16:22:25 -07:00
Sean Corfield
e173e397d2 Note the jdbc: prefix difference 2019-09-06 02:01:47 -07:00
Sean Corfield
7d936bec46 Note HikariCP needs :username 2019-09-06 01:50:20 -07:00
Sean Corfield
eed988896c Merge branch 'master' of github.com:seancorfield/next-jdbc 2019-09-06 01:43:47 -07:00
Sean Corfield
aa955ead80 Fix formatting; add link to seql 2019-09-06 01:43:25 -07:00
Sean Corfield
a0b4618083 Doc updates for PostgreSQL = ANY(?) trick 2019-09-04 19:19:32 -07:00
Sean Corfield
f1b8fea9bb Prep for 1.0.6 release 2019-08-24 12:05:45 -07:00
Sean Corfield
2a5e87cf22 Improve result set builder adapter docs 2019-08-24 09:14:02 -07:00
Sean Corfield
f95467a34c Improve docs for insert-multi! / execute-batch!
Call out the caveats more clearly. Note that Oracle doesn't support the 
`insert-multi!` syntax(!).
2019-08-22 13:09:07 -07:00
Sean Corfield
9a76e4c25a Add as-arrays-adapter 2019-08-21 14:47:55 -07:00
Sean Corfield
fed305dd2b Add and document as-maps-adapter 2019-08-21 14:19:32 -07:00
Sean Corfield
0049b007e5 Fixes #54 by adding new section to Getting Started 2019-08-21 13:30:33 -07:00
Sean Corfield
87e44ae6a6 Fixes #52 by using US-locale lower-case function 2019-08-08 17:01:23 -07:00
Sean Corfield
f4b8ff5cdb Prep for 1.0.5 release 2019-08-05 18:30:24 -07:00