Commit graph

51 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
68e62a77e1 Remove MariaDB support, enable buffer settings for SQLite. 2025-04-20 22:10: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
82e40b519f clean up 2024-07-12 02:57:19 +02:00
meecube
3e645e0e62 added missed cases in sqls 2024-07-12 01:46: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
55fa596e4d Fix mariadb healthcheck. 2023-09-26 21:34:28 +02: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
153320da01 Support defining database type as friendly string. 2023-09-23 00:44:32 +02:00
Sehkah
8ccb17fbbf Reduce differences between database schemas. 2023-09-23 00:06:03 +02:00
Sehkah
d6de0974f0 Reset default config json. 2023-09-22 00:54:07 +02:00
Sehkah
f7710f89f0 Fix PSQL time zone & ushort/uint issues. 2023-09-21 23:16:47 +02:00
Sehkah
8ab33bec40 Initial working state for MariaDB. 2023-09-20 01:16:34 +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
sebastian-heinz
37c218b58d tweak socket settings 2022-04-23 10:28:57 +08:00
sebastian-heinz
4dfab99214 update 2022-04-22 22:15:25 +08:00
sebastian-heinz
45e2a310ee update hook 2022-04-22 21:59:15 +08:00
sebastian-heinz
1349bbc324 test webhook 2022-04-22 20:11:56 +08:00
sebastian-heinz
aa1859a917 test 2022-04-22 19:32:13 +08:00
sebastian-heinz
d6079f1d04 test 2022-04-22 19:29:42 +08:00
sebastian-heinz
ef8c7c2e8f remove BOM 2022-04-22 19:26:32 +08:00
sebastian-heinz
165fb1eac5 create new branch 2022-04-22 18:26:01 +08:00
sebastian-heinz
7a14936660 update 2022-04-22 17:53:04 +08:00
sebastian-heinz
b200eaaef1 update 2022-04-22 17:31:14 +08:00
sebastian-heinz
8d9fe7f8db update 2022-04-22 17:25:31 +08:00
sebastian-heinz
3394db8ae6 test 2022-04-22 16:51:59 +08:00
sebastian-heinz
53ce3f1c5b test 2022-04-22 16:51:17 +08:00
sebastian-heinz
f19d14e8e7 self update 2022-04-22 16:48:54 +08:00
sebastian-heinz
dc772d46ea update 2022-04-22 16:42:00 +08:00
sebastian-heinz
544fa41d9b support service 2022-04-22 16:30:43 +08:00
sebastian-heinz
69ef07e6dd update deploy script 2022-04-22 15:34:37 +08:00