LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-02-2017, 06:12 PM   #1
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Rep: Reputation: 20
To Database or not to Database ?


I'm wondering. But I need the commentary of those more knowledgeable than me on this subject.

I have a genealogy website (http://www.loftusweb.com) wherein among other things is a "Registry" of names (and their story). Click the "Registry" link on the far left list.

Currently it is made up of an HTML page that links to one of 23 HTML pages that contain the info on the individual. There are more names than a few HTML pages could accommodate.

It seems that this is calling out for a database application. But what database and how does it link (or embed) to this site?

Ideally, it would be nice if an individual (after membership credentials) could post the info themselves.

I assume I would have to cut/paste the info from the 23 html pages, but could do that with a long weekend and bottle of wine.

Suggestions, comments?
 
Old 03-02-2017, 06:43 PM   #2
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 945

Rep: Reputation: 216Reputation: 216Reputation: 216
Yes.

That's the way to go.

By the way, I once knew a Loftus Simon in India (of all places). He taught science in Loyola College in Chennai, India. Should be about 75 years old now.

OK
 
Old 03-02-2017, 06:44 PM   #3
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 9,235
Blog Entries: 4

Rep: Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262Reputation: 3262
I guess that really depends on how much effort you want to put into it. If the total site fits on 23 pages, and if updates occur only rarely, then perhaps a bottle of wine would persuade you (or someone else) to continue update the HTML from time to time with various O'Contributions.
 
Old 03-02-2017, 07:00 PM   #4
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Family Name.

Check out https://gramps-project.org/wiki/inde...itle=Main_page

These 23 "pages" or "records" could easily be done is a non-database wiki such as Dokuwiki.
It's all text and very easy to maintain, use and manage.

Last edited by Habitual; 03-02-2017 at 07:03 PM.
 
Old 03-02-2017, 07:00 PM   #5
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Original Poster
Rep: Reputation: 20
Quote:
Originally Posted by AnanthaP View Post
Yes.

That's the way to go.

By the way, I once knew a Loftus Simon in India (of all places). He taught science in Loyola College in Chennai, India. Should be about 75 years old now.

OK


Simon Loftus authored a book ... link on the site.
 
Old 03-02-2017, 07:05 PM   #6
dijetlo
Senior Member
 
Registered: Jan 2009
Location: RHELtopia....
Distribution: Solaris 11.2/Slackware/RHEL/
Posts: 1,491
Blog Entries: 2

Rep: Reputation: Disabled
Quote:
then perhaps a bottle of wine would persuade you (or someone else) to continue update the HTML
Mmmmm... and he's got a geneology website... no screw caps in his wine cellar, I'll bet...
You know they invented a thing called Jinja templating ... on a related note, what vintage is the kind gentleman offering?

Last edited by dijetlo; 03-02-2017 at 07:07 PM.
 
Old 03-02-2017, 07:17 PM   #7
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Original Poster
Rep: Reputation: 20
Quote:
Originally Posted by Habitual View Post
Family Name.

Check out https://gramps-project.org/wiki/inde...itle=Main_page

These 23 "pages" or "records" could easily be done is a non-database wiki such as Dokuwiki.
It's all text and very easy to maintain, use and manage.


Thanks. I've emailed them to find out more.
 
1 members found this post helpful.
Old 03-02-2017, 07:19 PM   #8
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Original Poster
Rep: Reputation: 20
By way of clarification - each of the 23 pages of HTML contain about 20 listings of people (and their story).
 
Old 03-02-2017, 07:30 PM   #9
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Original Poster
Rep: Reputation: 20
Quote:
Originally Posted by dijetlo View Post
Mmmmm... and he's got a geneology website... no screw caps in his wine cellar, I'll bet...
You know they invented a thing called Jinja templating ... on a related note, what vintage is the kind gentleman offering?
I now know they have invented a thing called Jinja. I looked it up but it is beyond my austere capabilities. However, the wine is good but may contribute to the "austere" capability comment. Hic.
 
Old 03-02-2017, 07:42 PM   #10
dijetlo
Senior Member
 
Registered: Jan 2009
Location: RHELtopia....
Distribution: Solaris 11.2/Slackware/RHEL/
Posts: 1,491
Blog Entries: 2

Rep: Reputation: Disabled
Quote:
However, the wine is good but may contribute to the "austere" capability comment. Hic.
Drunk posting is a time honored tradition on Linuxquestions.org. Nothing like getting lit up like a Christmas tree while approaching strangers on the internet mumbling " Eeeeh... Hell yeah, I can fix your Linux box..."
 
Old 03-02-2017, 11:39 PM   #11
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 945

Rep: Reputation: 216Reputation: 216Reputation: 216
Loftus Simon, Chennai (Post #2)

Googling "loftus somon"+"loyola college" gave me this http://www.loyolacollege.edu/AlumniBulletin2006.htm

He died in Jan 2006. If you are interested in pursuing his case, you can email the contacts given in the above to ascertain whether he left any survivors and they know anything ..

OK
 
Old 03-03-2017, 07:01 AM   #12
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,873

Rep: Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600
FWIW, Perl does have 'tied hashes'; basically a perm stored on disk hash, which works well for simple 'DB' type storage + search & of course, lots of CGI modules..
However, once you start wanting to x-ref via eg SQL type queries, go for a real Db eg MySQL.
 
Old 03-03-2017, 10:35 AM   #13
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Original Poster
Rep: Reputation: 20
Quote:
Originally Posted by AnanthaP View Post
Loftus Simon, Chennai (Post #2)

Googling "loftus somon"+"loyola college" gave me this http://www.loyolacollege.edu/AlumniBulletin2006.htm

He died in Jan 2006. If you are interested in pursuing his case, you can email the contacts given in the above to ascertain whether he left any survivors and they know anything ..

OK
Many thanks for the info. I think this must be a different "Simon" as I believe the "author" is still alive. But, that being said, I'll do a little research. Thanks.
 
Old 03-03-2017, 10:38 AM   #14
loftus49
Member
 
Registered: May 2010
Location: Phoenix
Distribution: Ubuntu, CentOS5, Fedora, Mint, MX Linux
Posts: 165

Original Poster
Rep: Reputation: 20
Thank you all for your contributions. I will pursue looking into "Gramps", Dokuwiki and Jinja. You have given me a direction to go.
 
Old 03-03-2017, 06:50 PM   #15
dijetlo
Senior Member
 
Registered: Jan 2009
Location: RHELtopia....
Distribution: Solaris 11.2/Slackware/RHEL/
Posts: 1,491
Blog Entries: 2

Rep: Reputation: Disabled
Quote:
FWIW, Perl does have 'tied hashes'; basically a perm stored on disk hash,
Piffle, python has list comprehension that at this moment is sneering at your 'tied hashes'. The named tuple doesn't even deign to express it's disgust.
Goodness man, is this the dark ages?
 
  


Reply

Tags
database


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues with transferring a vBulletin 5 database (pics inside the database) AdultFoundry Linux - Server 4 08-19-2016 09:19 AM
Need to create or build a Linux database software to use my existing window base database backup Hidemitsu Linux - Newbie 6 03-30-2016 10:37 AM
NTOP Error Traversing Database for ipnum = - Perhaps database is corrupt? soslinux Linux - Networking 2 03-03-2010 06:28 AM
DBI Connect Failed:Access denied for user ''@'localhost' to database <database> error kaplan71 Linux - Software 3 06-05-2009 12:39 PM
Database Programming (database to database transaction) johncsl82 Programming 7 02-02-2007 08:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:47 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration