|
OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD. |
|
Thread Tools | Display Modes |
|
|||
Database for personal use
Hello,
I am interested in open source database for personal use cases. By personal use cases I mean to store address book (simple, I know), but also for example list of files for subjects I am studying at University. But I have some files, than can be useful for two or more subjects so I would like to "tag" them or make relationship of that record to two, or more, subjects (or vice versa). I have even created small, simple relational database in LibreOffice Base, but maybe there is something better (and initializes faster on OpenBSD) with GUI or at least CLI but for human easy enough for everyday use. The other needed property of that database is to be Cross-platform, so I can use the same file on Windows. |
|
|||
I don't have server or something like that. I can use Sqlite3 as a backend for LibreOffice Base via ODBC.
But what I want is some GUI for database or maybe GUI for making GUI for database. Especially to make local GUI to everyday use (like some people use Excel), preferably written in C,C++ or some other faster than php which is not server specific/dedicated. I don't know which word can describe what I want best so I am going to type a few: GUI for making GUI for database, database management program, front-end. But maybe using SQL commands is really so easy, so I can type it everyday? Last edited by e1-531g; 3rd December 2015 at 05:30 PM. Reason: to clarify and typo |
|
|||
I think that I have not found answer for what I am looking for
but at least somebody knows how to express in English what I am looking for. https://stackoverflow.com/a/66980 |
|
|||||
I'm moving this thread to the General Software subforum in case non-OpenBSD respondents have any suggestions, but given that the question appears to be OpenBSD-specific, the OpenBSD packages/ports subforum may be the best location.
Quote:
Quote:
Quote:
Quote:
Quote:
Last edited by ocicat; 3rd December 2015 at 07:52 PM. |
|
||||
Sounds like you could also just use a text file.
Code:
Carpetsmoker; carpetsmoker@example.com; 555-123123 ... Code:
filename; Tagname1, Tagname2 another_filename; Tagname1, Tagname2 ...
__________________
UNIX was not designed to stop you from doing stupid things, because that would also stop you from doing clever things. |
|
|||
You can even use the join(1) relational database utility to do a "equality join" on two text files
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump |
|
||||
I just posted a thread to the forum about a mechanism for "tagging files" :
http://daemonforums.org/showthread.php?t=9544 As carpetsmoker said, the database can be real simple for the OP's needs. If it worked reliably, extended file attributes would be an ideal way to tag files - that's really all it does. The only caveat is that it's so rarely used by people that its reliability is mostly untested. My post was mostly to find out if there were any negative issues with it. It's supposedly portable to Linux and OSX, but I don't see much real world testing of that facet either, and don't have a clue whether or not Windows would cooperate. It'd be an experment, that's for sure. |
|
|||
File attributes are not good for me, because I also use Windows. I want portable solution and easy to backup (without need to backup all filesystem), but not in Internet/Public Cloud. Preferably offline in files, but with option to run someday home server to be more mobile.
Using text files is interesting, but I hope that I have discovered something better. It would be great to design forms (it is not the same as designing tables in database) once, and then just use it everyday. |
|
|||
Quote:
Code:
--outformat <outputformat> ] [ --outfile <outputfile> ] Converts <inputfile> in <inputformat> to <outputfile> in <outputformat> (defaults are abook, stdin, text and stdout). The following inputformats are supported: - abook abook native format - ldif ldif / Netscape addressbook - mutt mutt alias - pine pine addressbook - csv comma separated values - palmcsv Palm comma separated values - vcard VCard addressbook The following outputformats are supported: - abook abook native format - ldif ldif / Netscape addressbook (.4ld) - mutt mutt alias - html html document - pine pine addressbook - vcard VCard addressbook - csv comma separated values - palmcsv Palm comma separated values - elm elm alias - text plain text - spruce Spruce address book - wl Wanderlust address book - bsdcal BSD calendar - custom Custom output format, see below Code:
set mutt_command = sylpheed --compose Another option is to look at both the client and server implementations of ldap. For example databases/openldap. The littlebrother db, databases/lbdb, I believe can utilize several different databases. Last edited by shep; 5th December 2015 at 06:55 PM. |
|
|||
Two things.
1. I have just discoverd TagSpaces. I have executed it on Windows, but project claims that it is open source and cross platform. Tags are added to file names, so it will be limited with filename length. The good side is that interface is very intuitive. 2. Question: Is in the OpenBSD ports tree any editor for XML files with GUI? |
|
||||
According to Wikipedia, Emacs can be used as an XML editor. That chart includes two browser-based XML editors also.
Last edited by jggimi; 22nd December 2015 at 02:01 PM. Reason: clarity |
|
|||
Drifting off topic but will add to the last 2 posts: devel/geany is extensible with plugins. editors/vim can also be tweaked.
man xmllint , that comes with textproc/libxml works well to format.
|
|
|||
Unfortunately, there is no direct equivalent for Access or FileMaker, which is what the OP seems to be really asking.
OpenOffice Base is a possibility though it's very crude compared to Access or FileMaker. I don't know about cross-platform its datafiles are. |
|
||||
Quote:
Tcl and SQLite work very well together. I think I remember hearing Dr. Richard Hipp (SQLite creator & maintainer) say that "SQLite started as a Tcl extension and then was released into the wilds". The Tk extension for creating portable GUI's is also deeply related to Tcl. |
|
|||
What about a wiki, such as www/moinmoin?
__________________
May the source be with you! |
|
|||
I would like to not use browser based solutions.
I will check Tcl/Tk:SQLite, xmllint, and... maybe I will in spare time write something lightweight and simple on my own, but it will take time... |
|
|||
database
I use gnumeric to import and/or manipulate files suitable for use in SQLITE3.
I also use sqlitebrowser or sqliteman as a gui front-end at times. I use the above programs on servers not internet connected, (internal lan) The result is limited compared to enterprise/specific software but serves our purposes. Then one could simply use SQLITE3 directly if inclined. |
|
||||
Quote:
The Tcl interface to the SQLite library might be useful. It starts by saying: Quote:
|
|
|||
If I will write this program, I will probably use XML
as a foundations of a format. As I stated before it is for personal purposes, so performance isn't needed. XML is good, because it can be read even by human in worst case scenario when my program could not read file created by self. I also think of Rust programming language, possibly with bindings to library written in another language. On the other hand I am also open to Java, because I also use Windows and "Write once, run anywhere" and backward compatibility is also excellent in this language/environment. Last edited by e1-531g; 15th February 2016 at 07:00 PM. Reason: Added second part |
Tags |
personal database |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
NetBSD into your personal computer ? | Adrien2002 | NetBSD General | 11 | 19th November 2015 11:06 PM |
Unbound Database | daemonbak | OpenBSD General | 2 | 21st July 2015 03:28 AM |
Personal Super Computer | Turquoise88 | General Hardware | 14 | 11th June 2010 02:01 AM |
PHP database interfaces | TerryP | Programming | 6 | 11th September 2008 01:03 PM |