Discussion Forum

JerryDi

Member

Registered: August 1, 2016

Posts: 3

Can I do this with BigTree?

Hi,
I am planning a website for a golf association centenary. There will be the usual standard pages, galleries, blogs etc, but I also plan to include the 100 years of club and player records. This is a fair amount of data eg ~ 2,500 players, 120 clubs, championship records, match records etc. All of this data I need to import from csv files.
I will need to design queries eg to show which players from a club represented the county, which ones won championships etc.
I've not used Bigtree before [I have used Expression Engine and Couch] So can you advise me if  Bigtree a good fit for this?
Many thanks
Jerry

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 978

Re: Can I do this with BigTree?

You shouldn't have any issues with a data set of that size - BigTree works great for relational data (many to many, one to many fields) as it's built on top of MySQL tables for each data type (rather than jamming them into a single table).

JerryDi

Member

Registered: August 1, 2016

Posts: 3

Re: Can I do this with BigTree?

Thanks Tim
Is there a facility to import csv files?
Jerry

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 978

Re: Can I do this with BigTree?

I'd recommend setting up your database tables first and then using something like phpMyAdmin or Sequel Pro to facilitate importing the CSVs.

JerryDi

Member

Registered: August 1, 2016

Posts: 3

Re: Can I do this with BigTree?

ok thanks.
It will be a while till I have the data ready but I will install Bigtree to get the hang of it before then