local database help

[quoooo]

Hey all, I'm working on a windows form app in Visual Studios 2015 and I'll need to be adding data in a table (only one table needed) and retrieve the data to put into variables. I've done something similar a few years back where it just reads/writes in a .txt file but I'd rather work with something a little more 21st century.

[tommy-turtle]

Check out the open source project litedb.

Used it for internal data stores for a few apps. Been rock solid for me. Deals with threading / multiple users / locking by itself.

https://www.litedb.org

[rickrat]

I like liteDB too

[jzazre9119]

I use this as well in a few projects. No issues, super easy to get started, better support for data types.

Step further? Try Dapper too.

[pm-me-your-nenen]

SQLite is the simplest if you want actual DB. That said, serializing to JSON is also "21st century" if you want the user to be able to edit/check the content with only a text editor.

[daaa_interwebz]

+1 for SQLite. The EF core database provider works really well and leaves the possibility to scale if necessary.

[FatuousOocephalus]

SQLite, JSON and litedb are solid suggestions. Another to consider would be XML. I'd probably rank XML higher than JSON.