I do the same as S, although I export data from a MS SQL database directly to XML, which in turn is read by Timeline at runtime. Like Larry says, this means it is always up to date and doesn't take long to query. The code is pretty straightforward, although it is written in ASP VBScript. If you want a copy of the script I wrote, i'd be happy to send it to you and you can try and parse it into a language of your choice to work with MySQL.
On Nov 24, 6:13 pm, Larry Kluger <[EMAIL PROTECTED]> wrote: > Hi Pascal, > > Sounds like you want to automatically create an xml file from your database. > > You can use a report writer for that, or write software to do it. Or hire > someone to write the software. > The software can be written in php, Java, Ruby on Rails, Perl or most any > language. > > You should also think about how often the data in the database changes. > If it changes once a day or less often then you might want to (automatically) > create the xml file at that time, then have your Timeline download the file. > > If the data changes all the time, then your software can query the database > when the Timeline page is loaded. That is the most dynamic way, but it puts > the highest load on your database server. So then the issue is how many > people will be looking at the Timeline page. The more that do, the more of a > load on your db server. > > If you're not a programmer then you should find one to consult with. > > Regards, > > Larry > > ________________________________ > From: cronjob <[EMAIL PROTECTED]> > To: SIMILE Widgets <[email protected]> > Sent: Monday, November 24, 2008 4:31:08 AM > Subject: Recieving from a mysql database instead of a xml file (Timeline) > > Hello, > I'm trying to work with data from a MySQL-database, but I don't want > to make every time a xml-file out of the database. Is there a way to > get data directly (maybe over a php script) into the timeline? > Any ideas? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
