I installed Gramps v5.2.2 on my Win10/64 bit machine with the goal to use PostgreSQL as database backend. So I selected the Shared PostgreSQL option in the settings and created a new database. No problem with that but when I tried to open this new database, I was welcomed with this window: [image] …

A lot of interesting and quite diverse ideas that were brought up by @StoltHD @ennoborg @Nick-Hall @SNoiraud – thanks! I would conclude that Gramps running with a PostgreSQL backend on Win10 appears to be not something we can find quite often :wink: I’ve done some other tests and would like to shar…

You also need to read the section about indexes on expressions . With its JSON capabilities SQLite can be used as a document store as well as a relational database. This hybrid functionality could suit us very well. The document store features have benefits: The one to one correspondence between…

[image] ennoborg: We already have an export to full relational SQLite. Is that what you mean? No. [image] ennoborg: If you don’t, you probably mean a program that replaces all pickled saved with the json.dumps method. Yes (I think). Just want a quick way to convert an existing databa…

[image] ennoborg: I also found that json_each function, but to me that feels like putting the horse behind the cart. and makes me think that the whole conversion to json is a waste of time, because it makes queries way more complex than we can have with a full relational DB, like the one used by…

[image] GeorgeWilmes: Just want a quick way to convert an existing database into one having all the same tables, with json instead of blobs. It could be good to keep all of the other existing columns, even though some are included in the json, because then we could compare index performance both…

[image] Nick-Hall: I don’t think that our objective is to create a full relational DB. If we wanted that we could just use RootsMagic for example. And I would probably use that, if my mother language were English, but it’s not. And Gramps is better than all programs made in The Netherlands, a…

[image] Nick-Hall: We were able to compare performance, but most indexes were still unused as they are in our current code. Right. I’m interested in querying from outside of Gramps, i.e. writing my own SQL queries as I have sometimes done with the current SQLite export. I’d like to gain some …

[image] Nick-Hall: If we wanted that we could just use RootsMagic for example. No, you couldn’t. RM (and all the other software packages I know of) is basically limited to GEDCOM. That means that it knows only events and roles that are supported by GEDCOM. Gramps is to my knowledge the only s…

[image] GeorgeWilmes: But if your PR includes a converted version of the “example” database, that is all I need, how can I download it? If you follow the link to the PR, you see Nick’s fork of Gramps. And if you clone that, and checout the proper branch, you can build and run that from source…

[image] ennoborg: This branch seems to have been merged with 5.0 If it has been merged with 5.0, it should still be in 5.1.6 and 5.2.2, right?

[image] UlrichDemlehner: Therefore Gramps is much more powerful as anything else on the market, but it is also much slower, and that should not be. I fully appreciate and accept you argument with the object framework you want to conserve and leverage, but there must be a way to combine this fram…

Error using PostgreSQL as database backend with Gramps v5.2.2

Help

emyoulation April 28, 2024, 8:35pm 83

Philip Wharram (@comeng) created a separate thread:

Topic		Replies	Views
PostgreSQL as backend on Windows Help	36	1098	December 11, 2025
JSON inside table Development third-party-addon , tools , data-import	33	729	December 16, 2025
Understanding Gramps 6.0 Development roadmap	24	2440	January 20, 2025
Performance Issues with Gramps Development hacks , performance	77	1805	January 6, 2025
Import from SQLite export Help third-party-addon	30	1410	March 2, 2023

Error using PostgreSQL as database backend with Gramps v5.2.2

Related topics