The easiest way to create a tiny database application on Linux

I am looking to create a very small cataloging application for personal use (although I would open it if I thought that someone else would use it). I don’t want the web application to look like overkill, to have an application server just for that - plus I like the idea that it is standalone and attaches it to a USB drive.

My criticism:

  • The interface should be easy to program. It could be a damn style if it makes coding easier. My experience with ncurses suggests otherwise, but I really really love the Commanline interface.
  • Language doesn't really matter. My rough order of preference (high first):
    • Python
    • FROM
    • C ++
    • Java
    • I will review anything linux-friendly
  • I think sqlite is for storage, but other (embedded) suggestions are welcome.

Has anyone done similar things in the past? Any suggestions? Traps to avoid?

EDIT:

Well, it looks like python + sqlite is an early winner. This just leaves the question of which ui library. I know that you get tkinter in python for free - but it's just so ugly (I would rather have a curses interface). I made GTK in C, but it looks rather unnatural in python. I had a very short problem with wxwidgets, but the documentation was pretty fierce IIRC (they renamed the module at some point, I think, and it all got a little confused).

So this leaves me with pyqt4 or some kind of console library. Or maybe GTK. Thoughts? Or am I too hasty to write off one of the above?

+3
4

pyqt wx . ( -, Python + sqlite .)

+2

(, -, ) - python sqlite3. , db. , .

+5

( ) python sqlite.

:

, -, . (, ) .

With sqlite, backups can literally be as simple as downloading or downloading the latest database file, depending on the timestamp of the file.

Then, if you lose or break a flash drive (broken into pieces, in my case), your directory will not be lost. You get more mobility, at least 1 backup and some peace of mind.

+1
source

You can also use bash to make an app.

-2
source

Source: https://habr.com/ru/post/1702221/


All Articles