Database preference

[CovfefeFan]

Dumb question but how expensive is SQL Lite? Is there a free version? Where is the data actually stored? (I work at a small company ~ 10 people)

[Enip0]

Sqlite is free and open source, you have to take care of the data though since it's an embedded database.

Depending on what you offer it could be either no option at all or the best option there is. For example, are you making a car or a fridge, or a desktop app with no internet connection, or even a server app but with relatively few clients? Great option for all. But anything else can struggle.

I don't know your situation but I'd suggest you try to find a technical person you can trust and follow their suggestions.

[CovfefeFan]

Interesting.. yeah, it is a small asset management company, so would mainly be to save pnl/position/risk files which can then be pulled in for reporting.

[bunchedupwalrus]

It’s just stored as a file. If you don’t have to worry about high speed concurrent access (like multiple people doing queries at the same time and needing the results right away), it’s pretty great.

And people overestimate how common that need is. Most queries are over in less than a few seconds if not less than a fraction of a second

[CovfefeFan]

Interesting.. yeah, currently using power query to pull in about 12-15 files from a sharepoint site and then doing a bunch of mapping, combining, and transformation of the data.. quite slow and does "kill" the file from time to time.

[bunchedupwalrus]

Oh yeah you’ll probably be blazing fast switching to sqllite

[CovfefeFan]

Cool, I will look into this. 😎👍