DaemonForums  

Go Back   DaemonForums > OpenBSD > OpenBSD Packages and Ports

OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 3rd December 2015
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default 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.
Reply With Quote
  #2   (View Single Post)  
Old 3rd December 2015
jggimi's Avatar
jggimi jggimi is offline
More noise than signal
 
Join Date: May 2008
Location: USA
Posts: 7,975
Default

I use sqlite3. It's included in base, and is an extremely lightweight SQL database -- I use it on small servers that store to compact flash devices. It can be used with any SQL application tools, or the included sqlite3(1) command line interface.

Last edited by jggimi; 3rd December 2015 at 11:05 AM. Reason: typo
Reply With Quote
  #3   (View Single Post)  
Old 3rd December 2015
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default

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
Reply With Quote
  #4   (View Single Post)  
Old 3rd December 2015
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default

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
Reply With Quote
  #5   (View Single Post)  
Old 3rd December 2015
ocicat ocicat is offline
Administrator
 
Join Date: Apr 2008
Posts: 3,318
Default

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:
Originally Posted by e1-531g View Post
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).
My suggestions would be either SQLite, or possibly Redis (databases/redis), depending upon the complexity.
Quote:
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.
"Better" is subjective, & your ultimate usage patterns may better define what will work best for you.
Quote:
The other needed property of that database is to be Cross-platform, so I can use the same file on Windows.
When it comes to compatibility across multiple platforms, SQLite may fit your requirements best.
Quote:
But what I want is some GUI for database or maybe GUI for making GUI for database.
There are unrelated software projects which meet this requirement for SQLite. Consider the following:These are obviously the ports specific to OpenBSD. I assume they may be available for other platforms too. Further research will need to be done on availability on other platforms.
Quote:
I think that I have not found answer for what I am looking for...
SQLite creates a database in a single file. This data file can be moved from platform to platform. The software used to manipulate this file will need to be specific to each platform used.

Last edited by ocicat; 3rd December 2015 at 07:52 PM.
Reply With Quote
  #6   (View Single Post)  
Old 4th December 2015
Carpetsmoker's Avatar
Carpetsmoker Carpetsmoker is offline
Real Name: Martin
Tcpdump Spy
 
Join Date: Apr 2008
Location: Netherlands
Posts: 2,243
Default

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.
Reply With Quote
  #7   (View Single Post)  
Old 4th December 2015
J65nko J65nko is offline
Administrator
 
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 4,125
Default

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
Reply With Quote
  #8   (View Single Post)  
Old 4th December 2015
rons's Avatar
rons rons is offline
Snoozing
 
Join Date: Oct 2015
Posts: 69
Default

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.
Reply With Quote
  #9   (View Single Post)  
Old 5th December 2015
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default

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.
Reply With Quote
Old 5th December 2015
shep shep is offline
Real Name: Scott
Arp Constable
 
Join Date: May 2008
Location: Dry and Dusty
Posts: 1,503
Default

Quote:
I am interested in open source database for personal use cases. By personal use cases I mean to store address book (simple, I know
<clip>
</clip>
The other needed property of that database is to be Cross-platform, so I can use the same file on Windows.
mail/abook may meet some your needs. The ncurses interface is quick, reliable and easy to learn. It imports and exports to many formats
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
Although it has mutt leanings, I have also used it with mail/sylpheed and mail/claws-mail by using the following ~/.abook/abookrc entry
Code:
set mutt_command = sylpheed --compose
Here are some screenshots.

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.
Reply With Quote
Old 22nd December 2015
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default

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?
Reply With Quote
Old 22nd December 2015
jggimi's Avatar
jggimi jggimi is offline
More noise than signal
 
Join Date: May 2008
Location: USA
Posts: 7,975
Default

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
Reply With Quote
Old 22nd December 2015
shep shep is offline
Real Name: Scott
Arp Constable
 
Join Date: May 2008
Location: Dry and Dusty
Posts: 1,503
Default

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.
Reply With Quote
Old 3rd February 2016
raindog308 raindog308 is offline
Fdisk Soldier
 
Join Date: Sep 2011
Posts: 67
Default

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.
Reply With Quote
Old 12th February 2016
hanzer's Avatar
hanzer hanzer is offline
Real Name: Adam Jensen
just passing through
 
Join Date: Oct 2013
Location: EST USA
Posts: 314
Default

Quote:
Originally Posted by e1-531g View Post
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?
Have you considered Tcl/Tk:SQLite?

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.
Reply With Quote
Old 12th February 2016
Beastie Beastie is offline
Daemonology student
 
Join Date: Jan 2009
Location: /dev/earth0
Posts: 335
Default

What about a wiki, such as www/moinmoin?
__________________
May the source be with you!
Reply With Quote
Old 15th February 2016
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default

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...
Reply With Quote
Old 15th February 2016
frcc frcc is offline
Don't Worry Be Happy!
 
Join Date: Jul 2011
Location: hot,dry,dusty,rainy,windy,straight winds, tornado,puts the fear of God in you-Texas
Posts: 335
Default 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.

Reply With Quote
Old 15th February 2016
hanzer's Avatar
hanzer hanzer is offline
Real Name: Adam Jensen
just passing through
 
Join Date: Oct 2013
Location: EST USA
Posts: 314
Default

Quote:
Originally Posted by e1-531g View Post
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...
Check out Tcl/Tk Tutorial and SQLite Tutorial. Also,
The Tcl interface to the SQLite library might be useful. It starts by saying:
Quote:
SQLite can be used with any programming language, but its connections to TCL run deep.
Unfortunately, the 5.8-stable sqlite-tcl port/package doesn't work so it won't be as simple as a few pkg_add commands then start scripting your GUI database application. Once I get email working, I might try to get the maintainer to develop a port patch.
Reply With Quote
Old 15th February 2016
e1-531g e1-531g is offline
ISO Quartermaster
 
Join Date: Mar 2014
Posts: 628
Default

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
Reply With Quote
Reply

Tags
personal database

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT. The time now is 03:52 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick