Looks like I've managed to break Trojan Asteroids mechanics with some BD modification. It's an old campaign, no other severe bugs, did nothing with astro tables except of DIM_SystemAbundance remake to have TN-poor space, and yet looks like no Trojan Asteroid group generated gains proper orbital parameters - all of them are just making oversun stright-line runs like pre-elliptic comets did in former times.

Nobody mentioned this in bugs topic, so I think it's because of my DB modification, though I have no clue how it's possible to ruin Trojan Asteroids and them only.

Does anybody know if it's possible to open two tabs for tables in DB Browser?

Technically, the database is SQLite. There are no native database editors for SQLite, unlike Access, SQL Server, Oracle, etc. I personally use Valentina Studio to edit SQLite databases.

I use DB Browser for SQLite, it's been serving me well. I'm even using it more to get info on my games, such as the total sum of RP spent by each race in the game, that I can't easily access otherwise.

It's less of an issue that you might mis-type something, the issue is you have no idea how the game will process the changes you made. Your goal "enable Conventional Industry" might cause the AI to do any number of weird things. There might be some part of the code which looks for this flag to determine conventional vs TN empire and prevent NPRs from forming correctly.

So to reiterate, don't report bugs if you have modified the DB, and don't complain if your 50000 hour game breaks. The only exception is that it might be useful to tell Steve about what happened if you have some reason to think it could occur in the base game.

Yes, of course.

To address the original question I think the program I've seen people mention was called something like DB Editor for SQL.

And here is the fun part, for I have found the holy grail...

Ladies and gentlemen! And all you wannabe modders!

The secrets we all were seeking, are at these internet coordinates:
http://aurora2.pentarch.org/index.php?topic=12695.0
It is our fellow forumite, xenoscepter, that made the thread "How to mod the DB? Any free programs to do it?" in #C Mechanics category. The name, was not very helpful using search function (though this may be my lack of... intuition).
Regardless, it has been found, and all of you, now may know what the key is -
It is SQLite. And a few others, mentioned in the thread coordinates.

May your crusade to fulfill your dreams of modding you take you wherever you please...
Again, keep in mind, this may cause bugs and other unexpected NPR behavior, which CANNOT be normal bug reports.
Only as, perhaps, an experience on how Your modding went.

So yeah. Anyone want to post "tales of modding" thread or similar? Sharing stories on how Your DB modding went...

Absolutely, there is no better way to introduce bugs of your own than editing the database. Even if you are skilled with databases it is incredibly easy to make mistakes with editing so you will break the database at least some of the time and quite possibly in ways that don't show up for a long time

Of course, this should be mentioned:

Dear readers, keep in mind, that if you do engage in the activities of DataBase modding, you will not be able to post bug reports! As Stve really hates chasing bugs that don't really exist in his original game...
You have been warned, either way...

Now with this warning aside, can we get back to the topic at hand?

Sorry for a... slight (or not so) necro - bringing a dead topic back to life - but, considering the name of this thread, I decided to ask here, rather than start a new one. I remember there were questions about what tools do folks use for DB editing, but I can't find it where...
So anyway - do You folks have any suggestions on database (I think file name is Aurora.db) editing? What tools/program to use?
Obviously first thing to do would be to create a backup...

My goal is to enable Conventional Industry in the game - to make various colonies and planetoids generate at least some sort of value, than just population and (Low gravity) infrastructure.

What was your experience with DB editing? Do you often edit it?

Also, does DB editing counts as modding? if yes, this should make the thread relevant in terms of thread category...

a) FCT_RaceSysSurvey lists systems known 'as a whole' by a given race (not surveyed, just entered somehow, you should see one system per race, fix it so it corresponds to the HW and not Sol).

b) FCT_SystemBodySurveys list specific locations surveyed by a given race.

Perfect, I miss those lines somehow! Thanks

PS: No problem with race creation, the errors appear when you cancel a system with a race in it as the current Aurora model cannot process it. But you can edit DB and remove the race there which is harmless.

But thanks for the concer and the advices though, really appreciated!

Hi all,

I am trying to create a game where I have 3 players controlled races starting on 3 different systems. I am familiar with DB editing so probably just ask for "directions" here.

So no problem in having 3 races and all 3 in 3 different systems.

The issue is that In Sol, with the main Human race, I can see all other races systems (I do delete all others leading to them).

Question then: Is there a way to remove from database knowledge of these systems to the human race?

At the moment I have to delete Sol all the times which includes the main race, deal with the errors, save, open DB and cancel the Humans.

I would really like to keep the Humans in play!