26 commits

Author	SHA1	Message	Date
sebastian-heinz	afc14ad4ae	Networking 2.x (#982)	2026-03-17 09:29:37 +08:00
Sehkah	e745f4470a	Document PSQL benchmark setup.	2025-05-23 18:29:55 +02:00
Sehkah	6520d83f1a	Add convenience script to convert SQLite schema without having to start up the application. ... Avoid "if not exists" in base schema as this is only expected to run once anyway, otherwise mariadb is not happy about conditional indexes.	2025-04-20 22:10:55 +02:00
Sehkah	f07263cf02	Expose more DB settings, experimental pgbouncer sample setup, optimized dotnet docker image.	2025-04-20 22:10:55 +02:00
Sehkah	080a868259	Refactor persistence layer, add new 37>38 migration.	2025-04-19 15:23:30 +02:00
Sehkah	aeaa2c8ace	Make pg_loader consume less RAM by batching.	2025-04-18 16:59:06 +02:00
Sehkah	af5392aebf	Update PSQL/MariaDB schemas with new indexes.	2025-04-18 13:22:20 +02:00
Sehkah	3fcfb9bfa8	Add indexes for slow queries to speed up some queries.	2025-04-18 13:22:19 +02:00
Sehkah	1bb35e08aa	Update sample PSQL config.	2025-04-18 13:22:19 +02:00
Sehkah	3ad433e611	Add pg_restore wrapper script for testing purposes.	2025-04-18 13:22:19 +02:00
Sehkah	586a2d0cbf	Add PSQL backup script.	2025-04-18 13:22:19 +02:00
Sehkah	6e6c503b47	Fix pgloader to deal with schema incompatibilities.	2025-04-18 13:22:19 +02:00
Sehkah	3e0ef64f2f	Add optional SQLite statement tracing & pgloader sidecar for PSQL sample.	2025-04-13 18:39:20 +02:00
Sehkah	50c245943d	Update to net9.0/C#13, expand range of item UIDs, fix docker builds, fix mariadb.	2025-04-12 17:01:55 +02:00
meecube	101f673aea	Restore upgrading functionality	2024-07-29 20:16:04 +02:00
meecube	b7f565f0a9	mostly implemented additional status to DB	2024-07-16 21:19:57 +02:00
meecube	b49902192c	clean up	2024-07-15 02:02:46 +02:00
meecube	76dab0944f	attempting to implement equippoints	2024-07-12 01:14:32 +02:00
Paul Campbell	c22cdc7eca	refactor: Removed unused jewelry_slot_num field ... Since the dragon force augment mechanic was implemented, the jewelry_slot_num field in the DB is no longer used, so remove it.	2024-04-30 08:17:14 -04:00
Sehkah	1a1926d868	Use SQLite schema as foundation & transform incompatible syntax to avoid multiple schema files.	2023-09-23 12:40:45 +02:00
Sehkah	8ccb17fbbf	Reduce differences between database schemas.	2023-09-23 00:06:03 +02:00
Sehkah	f7710f89f0	Fix PSQL time zone & ushort/uint issues.	2023-09-21 23:16:47 +02:00
Sehkah	21e24d82f8	Add initial required setup for MariaDB support.	2023-09-18 00:24:22 +02:00
Sehkah	78a1dee34f	Fix UTC-related timezone issues with PSQL. ... Note: Support for logging in with PSQL is provided now.	2023-09-17 22:51:52 +02:00
Sehkah	e2bed79923	Add PSQL-specific configurations and docker compose setup.	2023-09-17 17:59:01 +02:00
Sehkah	254d67bb34	Add simple PSQL config.	2023-09-17 17:41:01 +02:00