src/Pure/General/sql.scala
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;
Fri, 07 Jul 2023 14:20:58 +0200 wenzelm clarified signature: ensure disjoint data spaces;
Fri, 07 Jul 2023 14:17:53 +0200 wenzelm clarified signature;
Wed, 05 Jul 2023 14:33:13 +0200 wenzelm more robust;
Mon, 26 Jun 2023 22:15:56 +0200 wenzelm clarified signature: more options;
Wed, 21 Jun 2023 14:27:51 +0200 wenzelm clarified signature: more explicit class SQL.Data;
Thu, 15 Jun 2023 21:26:31 +0200 wenzelm obsolete;
Thu, 15 Jun 2023 17:24:32 +0200 wenzelm clarified signature;
Wed, 14 Jun 2023 12:10:40 +0200 wenzelm tuned signature: more operations;
Wed, 14 Jun 2023 11:47:43 +0200 wenzelm tuned signature: more operations;
Wed, 14 Jun 2023 11:18:25 +0200 wenzelm tuned signature: more operations;
Thu, 08 Jun 2023 14:45:31 +0200 wenzelm clarified signature;
Thu, 16 Mar 2023 16:28:21 +0100 wenzelm back to compression in Isabelle/Scala (in contrast to f7174238b5e3), e.g. relevant for old_command_timings_blob, but also for prospective heaps;
Tue, 14 Mar 2023 20:31:08 +0100 wenzelm more operations;
Tue, 14 Mar 2023 20:25:48 +0100 wenzelm more specific vacuum operation, which is also relevant to PostgreSQL;
Thu, 09 Mar 2023 12:54:19 +0100 wenzelm proper support for Option[Date] columns;
Thu, 09 Mar 2023 11:55:20 +0100 wenzelm clarified signature;
Wed, 08 Mar 2023 22:22:35 +0100 wenzelm more robust transactions;
Wed, 08 Mar 2023 22:08:48 +0100 wenzelm explicit locking for PostgreSQL --- neither available nor required for SQLite;
Mon, 06 Mar 2023 21:12:47 +0100 wenzelm clarified signature: reduce boilerplate;
less more (0) -100 -60 tip