From: Matthew W. <mat...@us...> - 2006-08-04 17:13:20
|
Ron wrote: > It now also read my usercode from the database, but i have some problems > reading the multiline records with perl line by line...HELP!? Post an example of what you are trying to accomplish and I'll try to figure out a solution. I'm curious as to what you believe the advantages are to storing perl scripts in the database as opposed to keeping them as text files. Or is this just something you are doing just to see if it can be done. > And I'm eager to leave out all support for hardware I don't have. But in > alI cases I will post the new routines I use. > That sounds like a good approach as it looks like you are more on the experimental side than trying to do active development for the community. Very interesting stuff though. > About the states. > This is the difficult part, I know they are stored in > data/mh_temp.states* I think about putting them in a status field of the > object/item they belong to, but have no idea if this is working and > slowing down the script. Use trigger functionalty of Mysql or maybe > leave those client/server via a tcp socket... > mh_temp.states is only updated once a minute, so it will only be useful for you for relatively stable state variables. Storing them in the database is a good idea, but only for the same purposes that mh_temp.states is for (restoring mh's object states on restarts), not for access. I recommend against anything based on TCP unless both the web server and mh are on the same machine. The reason is that a single packet loss can introduce relatively large delays. Use UDP instead as what you are attempting is real-time transfer of info. > About MySQL maintenance. > I think most Linux distros have MySQL installed by default or have a > user-friendly package util to add it. > Backing it up can be as simple as running 'mysqldump -p domo >>sql.backup' and save the file to tape,dvd etc. > Yes, backing up a database is easy, but for people not familiar with databases, it is something else to learn, the database package is something else to install (especially on Windows) and regular backups are something else to forget. I only mentioned this because if you want a wide audience for your project, then you need to look after the backups/maintenance automatically or if may not get done. Matt __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |