Other Software > Developer's Corner

Looking for lightweight, simple, portable/integrated database for Go

(1/3) > >>

Deozaan:
Hi all,

I've been thinking about writing a little utility for myself that could probably benefit from using a database of some kind. My needs will honestly be simple enough that I can probably just write everything out to a text (XML or JSON) or binary file, but on the chance that this is something that gets released and used by others who have a lot more data to wade through than I will, I figured I'd look into options of some sort of simple database system that might help keep things relatively speedy compared to parsing and iterating through plaintext to get all the relevant details.

The hard part about answering my request is that I'm not sure what language I'll be using for this utility. I'm most familiar with C# (but by no means an expert), so my inclination is to use that, but lately I've been tinkering with Python and Go and am considering using one of those if it would suit this project better. Also, cross-platform compatibility is somewhat important to me, at least between Windows and Linux. Ideally I'd like for my utility to have a GUI, but I'm pretty inexperienced with GUI frameworks and they tend to not always be very cross-platform friendly, and I'm not looking to make this a huge project that will take over my life for the next year. So for now I'd be satisfied with a command-line utility that can read, write, search, and display the pertinent information on demand.

Oh, and I'd like to be able to include the database with the utility in a portable manner, so the end-user can just run everything on a thumb drive or whatever without having to worry about installing things.

Maybe that was more information than needed. Anyway, can anyone recommend a simple and easy to integrate/use, portable database-type system that would be more efficient for parsing and looking things up than a plaintext (JSON/XML) alternative?

Thanks in advance

wraith808:
SQLite has been the go-to for that kind of database, though I utilized VistaDB (though got that for free from a review- it's actually a bit pricey).

https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki

https://www.nuget.org/packages/System.Data.SQLite

wraith808:
Also, I use this to manage my DBs.

http://sqlitebrowser.org/

There are others... though I haven't really tried any of them as that was enough.

http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/

Ath:
+1 for SQLite, it's used by default on Android and highly endorsed when using Xamarin, has support for nearly all platforms in use and bindings/libraries for many programming languages.

KodeZwerg:
A NoSql Variant could be MongoDB. It can be used by many programming Languages.

Navigation

[0] Message Index

[#] Next page