phpgedview and sqlite - is it the better choice for me ?

[droulez]

Hi ...

I'm new here ... I found nowhere else a living forum for phpgedview ...
I understand it's better to switch to webtree for a clean new installation, but, please, I need some help ...

I'm quite a noob in anything, and I'm installing a new home box under archlinux ... To this occasion, I'm willing to let go my myheritage subscription for a free web-based software I could access from anywhere, and host myself.

As I'm noob, I think it's more secure to get a sqlite based software, better than a mysql (as far as I understand, sqlite queries are based on local traffic, mysql queries goes through server and ports, even if http and mysql are on the same computer). If I can copy a php directory on a closed apache server (https + global authentification to access /), I just don't understand anything to SQL, and I'm worry to open security hole this way ...
(I would prefer a php software with no SQL at all, just gedcom, if I found one that permit to modify gedcom, not just generate some family tree !).

Maybe I'm wrong, and please, let me know !

I'm not quite sure to understand the way phpgedview works : it can import gedcom files (I already find that files exported from myheritage website are different than files exported by myheritage software !), but does it modify gedcom files on the fly, or does it store any work I could add to SQL base, and then export to GEDCOM file ?

And is the compatibility with other software absolute (I already see error with strange tags with myheritage, and I haven't scratched 1% of my 1.5 Mo gedcom file : if myheritage is not 100% gedcom compliant, how is phpgedview ?) ?

Is there anything I could read/do before getting further on in installing phpgedview ?

And with luck, is there any way I could easily pair phpgedview with PAM and pwauth ??

Thanks for the reading, Thanks a lot for the answers !!!!

[Stephen Arnold]

Why are you here?
PGV and webtrees best claim to fame is online collaborative viewing and editing of a shared family tree (GEDCOM file). The days of managing such a file via index and complete rewrites each time the file is altered are long gone. You must have a DB for either and it must be MySQL. A few have written some forks that handle other DB formats, but as constructed, and supported by the wider community, MySQL is the only DB.

You can always do your modifications offline, on your local-only server, desktop or laptop, but you lose the collaborative aspect. You then can export the GEDCOM file and use another program to produce static HTML pages for viewing the results on the web, but that's a lot of work and security risks for naught since PGV and webtrees can already do that simply by blocking edit privileges.

On any modern OS, I would not be installing PGV. It has not been keep current with many SQL and PHP changes, now for over three years. There is little support remaining.

Hope this helps.