? Richard
On Tue, Apr 21, 2015 at 2:29 PM, Ron Chatterjee <achatterjee...@gmail.com> wrote: > Is this the link that takes to genealogical research? > > On Tuesday, April 21, 2015 at 12:04:29 PM UTC-4, Richard wrote: >> >> And what about just using Gramps (https://gramps-project.org/features/)?? >> >> Richard >> >> On Tue, Apr 21, 2015 at 2:08 AM, John <jhnp...@gmail.com> wrote: >> >>> New to programming and web2py. Been dabbling in web design for a while, >>> building sites with wordpress, plugging things in. My first real project >>> will be a site/app for my sister. Genealogical resources. Lots of records >>> that will need to be added via csv and also via forms. Will also need to be >>> displayed in sortable grid/table format and will need advanced search >>> capabilities. These records will be things like births, deaths, marriages >>> etc and would have anywhere from 10-20 fields for things like; surname | >>> given name(s) | DOB | State | County | City/Town | Father surname | father >>> given name | mother surname | mother given name | source. >>> On the site, people would most likely browse by clicking a State, then >>> the County and then Birth records at which point they would see the >>> sortable grid/table with all birth records for that County, State. >>> Else they would go to an advanced search page where they would choose >>> the record type from a drop down, State from a drop down which would then >>> populate a drop down for Counties of the chosen State. A choice for all >>> States/Counties would be nice. Names, they would type in. DOB could be >>> typed in as well though it would be nice if they could choose a date or >>> date range. Some records may only have a partial date like maybe just the >>> year. >>> Each record type will have all the same fields of course so it only >>> makes sense to have a table for each. There will be approx 20-30 different >>> record types. I thought about individual tables for each record type for >>> each state but that would be 51 tables(50 States plus DC) times however >>> many record types there ends up being so 1000-1500 tables. Seems like too >>> many. >>> I'm in no rush and realize I have a lot of work to do and a lot to >>> learn. At some point this site will hopefully become a community based site >>> so membership and permissions will be needed. A forum would be nice but I >>> haven't seen anything regarding that in the documentation yet. But first >>> and foremost is the data records. I've read that each application gets it's >>> own database so I'm thinking my first/main app would be *Records* with >>> db tables for births, deaths, marriages etc. Am I correct in thinking that >>> a table for each record type would be best and to not break it down by >>> State but rather make State a field/column? Then again, when/if we end up >>> with lots of records, that would be a lot of rows considering the number of >>> births in the USA over a period of a few centuries. >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "web2py-users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to web2py+un...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
