.sql files in pre-load

[sosueme]

Beg pardon if this has been covered somewhere, but I couldn't find the answer I was looking for when searching.

I was poking around the Steam pre-load and noticed a lot of .sql files. Does anyone know what database engine Civ V is running on the back end?

 

[Drago Askani]

Thats probably the encrypted files to prevent piracy, etc.

 

[sosueme]

Everything is saved in what looks like an encrypted format from my pre-load (.xml files, etc). I'm just curious because .sql files are typically saved SQL queries and I'm a bit of a database nerd IRL.

 

[Drago Askani]

Oh you got me, I am a hardware geek mainly. The programming side of things isn't my strong suit.

 

[vaugula]

I'd say they are sql scripts given the extension. Given that civ games have a lot of information to track, a database being involved sounds like a reasonable idea to me. Perhaps the save game files are databases?

 

[Meneer Popken]

How big are those files? If they are database queries the biggest should be no more than a few kilobytes, most of them far less.

 

[sosueme]

How big are those files? If they are database queries the biggest should be no more than a few kilobytes, most of them far less.

Correctamundo, biggest is about 5K, most are less than 1K.

 

[Dale]

Beg pardon if this has been covered somewhere, but I couldn't find the answer I was looking for when searching.

I was poking around the Steam pre-load and noticed a lot of .sql files. Does anyone know what database engine Civ V is running on the back end?

I'll tell you Tuesday.

 

[sosueme]

I'll tell you Tuesday.

Melbourne eh? My Tuesday or your Tuesday?

Is it SQLite?

 

[Dale]

Yes, your Tuesday.

 

[Meneer Popken]

It is SQLite.

 

[Dale]

The game loads all the XML data and processes it into an SQLite database. These are stored in the cache folder (from memory).

Mods will create a separate SQL database so that the vanilla database is not corrupted. All mods will store info in one database.

If there is a data loading issue in Civ5, first step to take is delete all SQL files from the cache folder (they're recreated on load).

Oh, and to pre-empt the question, you CAN write a program to SQL query the database (that's actually how Firetuner works).

 

[sosueme]

...never mind...

Thanks again for your insight. I can't wait to get my hands on the dev kit.

 

[sosueme]

The SQLite Manager Firefox Plugin is pretty nifty...

https://addons.mozilla.org/en-US/firefox/addon/5817/

...just sayin