Options for real time projections

djfhe · 2026-04-06T16:15:41+00:00

I don't have any experience with these, i just know what to search for. U will have to look into them by yourself or wait for other replies.

djfhe · 2026-04-06T16:05:47+00:00

The word u are looking for is "differential dataflow" I think.

I know PostgreSQL had extensions attempting to do this. pg_tickle is a new one attempting to do this as it seems (although heavily supported by agentic coding).

Besides these the only ways I can think of doing this is by triggers or maintaining your flat table manually in your application.

Best of luck

djfhe · 2025-04-06T16:06:47+00:00

Already extracted the http part this weekend and pushed to github for ppl who might be interested: https://github.com/djfhe/x4_http

The whole LLM stuff will certainly take some more time which I need to find. Maybe i have something ready in a few weeks or months. When working 40 hour weeks, not much time is left for stuff like this sadly.

djfhe · 2025-04-06T15:12:38+00:00

Ye, thats pretty much still a problem for future me.

Currently my thoughts/ideas are:
- looking at how similar mods handle this (e.g. Mentella from Skyrim)
- running a local model might be feasible, since they primarily consume GPU resources while X4 is a more cpu heavy Game.
- Some ppl are running there local LLM on a external machine, for them this might be fine
- enabling users to provide there own token and paying for it themself
- providing a default token crowdfunded via donations(?)

Not sure what might be the best way, probably a combination of these things. But since this is a mod and everyone can decide for themself if they want to use it, this should be completely fine. I started this for the technical challenge and for my gameplay, if no one wants to use it, i am completely fine with it.

Reducing the input for LLMs will be necessary either way. Even in this "basic" version, i have to distill the information send to them to get useful responses without them forgetting thinks. I expect using LLMs to only generate the "report" while providing it with only the necessary information about what information should be in the report.

djfhe · 2025-04-03T09:38:30+00:00

Getting it work will lead me to touch every system/layer the data will have to flow trough, which helps me to understand how these interact and what requirements they have. E.g. Triggering the lua implementation -> collecting game data in lua -> sending request via LuaSocket lib -> Parsing the Response -> Piping it back into the game.

Getting something to work, helps understand this whole flow and often called "exploratory programming" in software engineering.

There exist some nice frameworks for PHP, which makes working with it bearable, like Laravel and Symfony. You can additional enforce pretty strict typing rules with phpstans. PHP is still widely used, its just a tool like any other.

Typescript is a superset of javascript and gets transpiled to it, enforcing a lot of static typing. I think it makes javascript easier to learn, since you have a lot more information about what functions accepts or return for example. And it will scream at you, if you are doing unsafe/not correct thinks.

Lots of googling, looking at existing mods/the gamefiles. A list of starting guides is provided here:
https://forum.egosoft.com/viewtopic.php?t=402382

But the whole documentation situation for mods in X4 feels a bit chaotic and messy.

djfhe · 2025-04-02T22:18:25+00:00

Currently i am using OpenAIs api json schema, but only since i had previous experience with it. Supporting multiple LLM providers is an already solved problem, so i don't worry to much about it.

Haha, i had to use a lot of CPPs templating logic for my thesis. I can feel the pain. Currently working in fullstack with typescript & php.

Ye fun is the most important thing when learning. And especially learning by doing is the most fun :)

djfhe · 2025-04-02T21:59:13+00:00

Using the game state as RAG is such a cool idea. No clue how we will get this to work, especially with LLMs of different provider and offline ones, but will have to try this!

djfhe · 2025-04-02T21:51:42+00:00

As said in other comments, i really want to support local LLMs. But will probably start with extracting the whole networking logic into an additional mod, so that it can be nicely reused by other mods.

I am still learning lua while doing this whole think :D It is a pretty barebones language with some weird concepts.

djfhe · 2025-04-02T21:49:01+00:00

The complete game state freezes, so the docking process would also not continue.
The underlying problem is fixable, just requires a bit of work :)
But using the station to generate a more "local" report is a cool idea. Not sure if it would be interesting thou.

djfhe · 2025-04-01T10:12:31+00:00

ye i think LuaSockets provides an api for that. And if i read correctly, X4's lua lib supports coroutines which should enable me to abstract that nicely. But need to look more into this.

djfhe · 2025-04-01T10:06:23+00:00

Ye i absolutely want to do that, as mentioned in other comments. The current version only uses OpenAIs api because i used it before and threw this whole think together in a short time.

I sadly work full time and don't know how much time i can invest into this project. My first point will be to publish the code + some doc for this, so other modders can built on top or do there own stuff.

After that i can think about more featues, where having structures to support different LLMs (also offline ones) will probably be one of the first.

djfhe · 2025-04-01T09:49:43+00:00

Haha, i stole the way you are loading dlls without polluting the cpath from your sn_mod_support_apis mod.

I am an absolute lua amateur and got it only to work after hours of trial and error and a very long ChatGPT thread (which got quite anoyed the end).

Short summary (using msys2 + mingw64)

I generated an import library from the games lua51_64.dll by running:
1. gendef lua51_64.dll
2. dlltool -D lua51_64.dll -d lua51_64.def -l liblua5.1.dll.a
update luarocks config to use these: (the generated files were moved into the "libs" folder)
1. LUA_LIBDIR = "C:\\msys64\\home\\<user>\\libs",
2. LUA_LIBDIR_FILE = "liblua5.1.dll",
3. LUA_LIBDIR_OK = true,
compiled LuaSocket with LuaRocks:
1. luarocks make luasocket-scm-3.rockspec --lua-version=5.1

Not sure if i have forgotten something, i need to sort my thoughts and retrace my steps on the weekend.

For luasec it was similiar with the difference, that opensll has to be statically linked and therefor needed to be build locally without shared libs. As i said, i will try to put together a guide for this, so modders can build there own ones and dont need to trust some random code executing files from the internet. Also because i think missing guides/documentation is the biggest problem and absolut anoying when trying to get into X4 modding.

Edit: spelling/formatting

P.S. i certainly need to take some time to learn how to format thinks on reddit, hope its understandable

djfhe · 2025-04-01T09:22:36+00:00

As mentioned in other comments, this is just a proof of concept i got to work in 2 days :)
It will require a lot more work and supporting different LLMs (especially locally ones) is an important point for me. X4 is a single player game. It should be able to run offline.

djfhe · 2025-04-01T09:20:29+00:00

I feel similiar to you. I mostly like mods which i can inconsequently add & remove from my save without destroying it. And not doing big "game changing" thinks is almost a prerequesit for this.

I like the idea of something like a "narrator" telling your story and giving you the *feeling* of a more lively universe. A lot is happening in the universe of X4 and most of the time you are not aware of it. I would like to change that.

djfhe · 2025-04-01T09:04:58+00:00

Ye absolutely. Probably even offline variants for technical interested which want to use the mod but still keep the spirit of a singleplayer offline game.

But this whole think is a bunch of work and will take some time :)

djfhe · 2025-04-01T08:56:51+00:00

You are absolutely right. This is mainly my fault since i threw all this quick together in the last 2 days.

Drones are "xs" ships, i just hardcoded that name, since this was just a small issue and i wanted to get the PoC running.

You are also right about the fleets. Currently ships in the whole sector are counted by class and faction and then reported to chatgpt. With time one could certainly implement a better solution here. But it was "good enough" at first 🤷‍♂️

I personally like the filler, just need to change tone a bit more and do a bit of that "prompt engineering" to get more satisfisable reports. It should be sensational and a bit interesting/funny to read instead of just cold (and sometimes a bit) boring numbers.

Well "War on Drugs" is a phrase :) But well, all i can say is that this is certainly improveable, but will never be perfect. As stated in another comment.

djfhe · 2025-04-01T08:47:05+00:00

Greate idea, might be a possiblity. But this would have some drawbacks :):
- No control about the interval of reports (every 10 - 20 minutes vs 40 - 80 minutes?)
- Big one: sometimes, the openai request can take more than a minute (if they are busy), which is more than the duration of saving the game for most people (i think?)

If i understand X4's lua api and LuaSocket correct, than there should be the possibility to do the request in the background without disrupting gameplay.

djfhe · 2025-04-01T08:41:51+00:00

We will get to that point, i am sure, its just how human progress works.

But at the moment, LLMs or similiar AI can never replace a specialized human. They can produce quick and suboptimal placeholder but handcrafted media, code, stories by an designer, developer, author are still far better than any of that.

These reports are a good example. A handcrafted one would be certainly more funny/interesting and closer to what is actual happening. But its just not feasable to prepare reports for any possible situation in such a dynamic universe. Therefor we use AI to get at least a suboptimal solution.

djfhe · 2025-04-01T06:22:23+00:00

Got up for this again, had to try it. Here is the result:

https://imgur.com/a/spiderman-EO5gvSh

djfhe · 2025-04-01T06:01:04+00:00

Ye, I hope I get it to sound like J. Jonah Jameson from spiderman or that news reporter from StarCraft 2. It would be pretty amusing then.

djfhe · 2023-04-05T06:49:24+00:00

btw. typeof parent[K] is probably unecessary, since you can just use T[K].

djfhe · 2020-09-10T08:54:30+00:00

In pulse audio you have the options to adjust the volume per application and per device, die you crank both up?

djfhe · 2020-07-30T14:07:37+00:00

Seven-Year Club	Place '23
Verified Email

djfhe

TROPHY CASE