src/Pure/General/sql.scala
Sun, 25 Feb 2024 20:13:08 +0100 wenzelm tuned signature;
Sun, 25 Feb 2024 18:47:14 +0100 wenzelm tuned signature: follow PostgreSQL syntax instead of JDBC API;
Sun, 25 Feb 2024 14:53:59 +0100 wenzelm more robust shutdown: interruptible database connection;
Sun, 25 Feb 2024 13:17:39 +0100 wenzelm clarified signature: more convenient send/receive operations;
Sat, 24 Feb 2024 22:56:56 +0100 wenzelm clarified versions for documentation;
Sat, 24 Feb 2024 22:10:54 +0100 wenzelm clarified signature: avoid hardwired values;
Sat, 24 Feb 2024 22:07:21 +0100 wenzelm clarified IPC via database server: receive notifications quasi-spontaneously via auxiliary thread;
Fri, 03 Nov 2023 18:58:53 +0100 wenzelm proper SQL.string syntax, following actual SQL standard instead of historic variations before PostgreSQL 9.1;
Tue, 31 Oct 2023 14:35:51 +0100 wenzelm discontinued pointless option (reverting 63d55ba90a9f): performance tuning works better via SQL.Database.execute_batch_statement;
Tue, 29 Aug 2023 17:14:19 +0200 wenzelm tuned indentation;
Tue, 29 Aug 2023 16:30:07 +0200 wenzelm clarified signature: prefer enum types;
Tue, 22 Aug 2023 10:31:15 +0200 wenzelm tuned output;
Mon, 21 Aug 2023 20:40:15 +0200 wenzelm proper sequential evaluation;
Mon, 21 Aug 2023 15:04:22 +0200 wenzelm clarified signature: proper treatment of implicit state (amending d0c9d277620e);
Mon, 21 Aug 2023 12:34:53 +0200 wenzelm clarified signature: more robust treatment of implicit state;
Mon, 21 Aug 2023 11:24:47 +0200 wenzelm tuned messages;
Mon, 21 Aug 2023 10:53:50 +0200 wenzelm more operations;
Sat, 19 Aug 2023 22:57:06 +0200 wenzelm clarified signature: filter batch;
Sat, 19 Aug 2023 14:34:36 +0200 wenzelm support for execute_batch: multiple statements in one round-trip;
Fri, 21 Jul 2023 11:05:50 +0200 wenzelm tuned output;
Wed, 19 Jul 2023 10:56:19 +0200 wenzelm clarified options;
Tue, 18 Jul 2023 23:03:39 +0200 wenzelm more options for performance tuning;
Tue, 18 Jul 2023 12:50:34 +0200 wenzelm more uniform guard (!exists_table(table)): avoid "ALTER TABLE" on already existing table, which could lead to deadlocks if this is presently locked;
Tue, 18 Jul 2023 12:39:20 +0200 wenzelm removed unused "create_index": implicit index from primary_key is usually sufficient;
Tue, 18 Jul 2023 12:32:07 +0200 wenzelm clarified "vacuum" (again, reverting 0bd366fad888);
Tue, 18 Jul 2023 12:19:12 +0200 wenzelm clarified signature: eliminate SQL.Tables.empty to avoid confusion (see also 0bd366fad888);
Mon, 17 Jul 2023 21:35:27 +0200 wenzelm more elementary transaction implementation (despite fda3f7a158b9 and 9da65bc75610);
Mon, 17 Jul 2023 20:44:58 +0200 wenzelm proper check (amending 234f2ff9afe6);
Mon, 17 Jul 2023 20:32:19 +0200 wenzelm more robust: exclude accidental nesting (synchronized block is re-entrant);
Mon, 17 Jul 2023 16:09:59 +0200 wenzelm removed junk (amending f8e3b228670c);
Mon, 17 Jul 2023 16:02:28 +0200 wenzelm tuned output;
Mon, 17 Jul 2023 12:22:39 +0200 wenzelm tuned source structure;
Mon, 17 Jul 2023 12:15:06 +0200 wenzelm clarified signature: more specific exists_table --- avoid retrieving full list beforehand;
Mon, 17 Jul 2023 11:20:28 +0200 wenzelm more informative trace;
Sun, 16 Jul 2023 19:38:12 +0200 wenzelm tuned output;
Sun, 16 Jul 2023 19:30:10 +0200 wenzelm make double-sure that this is a transaction context, notably for LOCK TABLE;
Sun, 16 Jul 2023 19:13:08 +0200 wenzelm more robust Java/Scala multithreading: transaction is always connection.synchronized;
Sun, 16 Jul 2023 15:53:13 +0200 wenzelm clarified signature: more operations;
Sun, 16 Jul 2023 14:19:36 +0200 wenzelm more standard time unit;
Sun, 16 Jul 2023 13:45:46 +0200 wenzelm tuned output;
Sun, 16 Jul 2023 13:41:00 +0200 wenzelm global transaction_count;
Sun, 16 Jul 2023 12:34:41 +0200 wenzelm tuned output;
Sun, 16 Jul 2023 11:46:53 +0200 wenzelm clarified isabelle.transaction_log: support time_min (in ms);
Sun, 16 Jul 2023 11:29:23 +0200 wenzelm more informative trace;
Sun, 16 Jul 2023 11:03:10 +0200 wenzelm support trace of transaction_lock via property "isabelle.transaction_log";
Sun, 16 Jul 2023 10:50:40 +0200 wenzelm proper db.transaction_lock instead of adhoc clone (amending 2df0f3604a67);
Sun, 16 Jul 2023 09:54:55 +0200 wenzelm tuned;
Sun, 16 Jul 2023 09:50:42 +0200 wenzelm proper close() operation;
Sun, 16 Jul 2023 09:34:30 +0200 wenzelm tuned comments;
Sat, 15 Jul 2023 19:55:32 +0200 wenzelm less ambitions transactions (amending 3f3dcf9f53f1): TRANSACTION_SERIALIZABLE may lead to spurious rollback exceptions;
Sat, 15 Jul 2023 19:34:48 +0200 wenzelm clarified signature: more operations;
Sat, 15 Jul 2023 13:38:01 +0200 wenzelm clarified signature;
Fri, 14 Jul 2023 16:53:39 +0200 wenzelm clarified signature;
Fri, 14 Jul 2023 14:25:53 +0200 wenzelm tuned;
Fri, 14 Jul 2023 14:21:22 +0200 wenzelm clarified signature;
Fri, 14 Jul 2023 13:31:05 +0200 wenzelm clarified signature: more uniform SSH.Port_Forwarding;
Sun, 09 Jul 2023 14:33:45 +0200 wenzelm clarified "vacuum" operation for various database versions (PostgreSQL <= 10 is strictly speaking obsolete, but still used on some test machines);
Sat, 08 Jul 2023 19:28:26 +0200 wenzelm clarified operation: sequential vacuum to support obsolete versions 10 and 9.x;
Sat, 08 Jul 2023 19:14:09 +0200 wenzelm clarified operation: empty means "empty" instead of "full";
Sat, 08 Jul 2023 13:13:10 +0200 wenzelm clarified signature;
less more (0) -100 -60 tip