[geeqie] Re: Geeqie image DB: thoughts and considerations?

  • From: Klaus Ethgen <Klaus+geeqie@xxxxxxxxx>
  • To: geeqie@xxxxxxxxxxxxx
  • Date: Tue, 6 Mar 2018 20:17:39 +0100

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Hi Omari,

welcome back to us. :-)

Am Mo den  5. Mär 2018 um 21:05 schrieb Omari Stephens:

I'm brainstorming over a side-project that may require integrating some kind
of DB into Geeqie.  I know that having a DB has been on the roadmap for a
long time, so I'd like to implement things in a way that will be compatible
with the usecases that people had in mind.

It feels like a foregone conclusion that SQLite is the right way to go with
this.  I quickly looked at BerkeleyDB, but it doesn't have any of the
utilities that SQLite does, so debugging and maintaining things would likely
be a pain.

I'll also vote against berkeley and for sqlite. From the current
perspective that looks like the best idea.

Some thoughts I have:
- - It should be clear what to store in the database and what not.
- - There should be ways to export/import to other files
- - Maybe some API access for scripting/lua

Especially the import/export idea is something I care much. Currently I
use the git-annex metadata to persistently store metadata with images. I
have tools to export/import them from/to metadata in .metadata dir.

Maybe that could be improved a bit. :-)

Regards
   Klaus
- -- 
Klaus Ethgen                                       http://www.ethgen.ch/
pub  4096R/4E20AF1C 2011-05-16            Klaus Ethgen <Klaus@xxxxxxxxx>
Fingerprint: 85D4 CA42 952C 949B 1753  62B3 79D0 B06F 4E20 AF1C
-----BEGIN PGP SIGNATURE-----
Comment: Charset: ISO-8859-1

iQGzBAEBCgAdFiEEMWF28vh4/UMJJLQEpnwKsYAZ9qwFAlqe6UwACgkQpnwKsYAZ
9qymjgv8DHbfHgfDeq7EcEpoE3gzFRIrMO+cIJGyofisKhAnBmifW2HcM9eJeWYG
6n7GebssQLtwDkgzr/s3FYZLcOhPbMAKEaOzA5NsvwagBomCGP1A/Wmlx1gKvWua
RlNDchpLhqFZEW/2vM+f9M5vFAZR6BbazrFRQq9vUIOyJduk/1JSifnnq//Pu/iM
4hyqkr5nHC7D9oFt3j6rUd1SnfdBWKmZ6oZU2rbMtolQce3SnSqmmDHgJESAG6Bg
z1EDnbnJfDqZ9MrFXSX2lqcHoPjMeg9F47LsmGG8fqaJrr1oMCRYwAZ5UUUoknuQ
U0xaUG3JGFG3kOSe/pJoTfaib8JxnV76rp6opIIVaBTZLulfAMIPp/cBqolcqmJH
5XoOFWCNTE+YS4D5DSOaK8gtHmvTgtTSS17hYZOePArhzrH+Cld6A/JG+0RP5VMk
S4sNro4R1KmaEz8Lkjw9NwArYHL2ZN/BpLbD8ERvoX0Z1Zz6g/PuahmZf1CFutVJ
0sQq1QFk
=ue9N
-----END PGP SIGNATURE-----

Other related posts: