UI to access db
nbinont at gmail.com
Sat Dec 29 00:26:52 EST 2007
On Dec 28, 2007 4:58 PM, Phil Longstaff <plongstaff at rogers.com> wrote:
> Well, I guess it's time to tackle the db selection/UI issues.
> The gda backend accepts URLs:
> - gda://<provider>:<dbname>
> - gda://@<gda_config_name>
> where <provider> is the provider name ("sqlite", "mysql" or "pgsql").
> If the first form is used, for mysql and pgsql, the dbname is the name
> of the database, while for sqlite, the dbname is the name of the dbfile
> (libgda adds ".db" to the end of the db file). If the second form is
> used, gda_config_name is the name of a libgda configuration stored in
> ~/.libgda/config (I believe libgda supplies a tool to configure these).
> It also accepts file://<filename> URLs. If the filename has the ".db"
> suffix, then it will be used if it exists and is an sqlite file or if it
> doesn't exist. If it doesn't have the ".db" suffix, then it will be
> used if it doesn't exist. This leaves the XML backend to handle
> xml://<filename> URLs and file://<filename> URLs where either the
> filename has ".db" but isn't an sqlite file, or doesn't have ".db" and
> does exist.
> The current file-based Open/Save As dialogs will work for XML and sqlite
> files, but not for the other db engine databases.
> 1) Modify the Open/Save As dialogs to allow it to handle gda:// URLs.
> 2) Leave Open/Save As to handle files, and add a "DB Connection" menu
> item/dialog. If there was a session active, this user could save the
> contents to the session (or not) and could load the db. This provides
> the db counterparts to Save As and Open respectively.
> My preference is for #2. Of course, the DB connection dialog would
> create the gda:// URL which would then be persisted from session to
I think #2 makes more sense as well. If we ever move to a db backend with
any sort of multi-user capability (yes, long ways down the road, I know) the
modified open/save as dialogs would probably get confusing for the user.
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
Ever notice something? Linux comes with compilers. Vista comes with
More information about the gnucash-devel