[PHP-DB] MySQL/Gemini now free - any feedback??
Hi Just noticed that NuSphere are now including the Gemini table type in their free binary download. It seems that everything is there, apart from the online backup, which is only available in the commercial version. I need transactions, and took a look at InnoDB. But it seems to have some pretty serious drawbacks, such as fixed table sizes, not being able to provide cardinality info to count(*), a manual that assumes you have a PHD in database application programming etc. The Gemini table is based on an enterprise proven Progress embedded database engine, and would seem the way to go. Has anyone got practical experience of deploying it on Linux? Any feedback would be much appreciated. Geoff Caplan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Cookie effect
David > problem is, the cookie only comes into effect after I've clicked thru to > another page from login.php...any ideas on this? You don't explain why you need to access the cookie immediately. If you just want to check it has been accepted, the usual approach is to use headers to do a redirect back to the same script. Then you can check if the cookie is there. You need to use a POST or GET variable to indicate whether you are in cookie writing or cookie checking state. If this is a public site, be aware that some search engine bots don't like fast redirects and will not index anything below this script on the site. You can also do this with JavaScript I believe - not very reliable on the open web though as it may be missing/turned off in the target browser. If you look at the archives for the general mailing list you will find some sample code. Hope this is useful Geoff Caplan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] DBA functions - any experts out there?
Hi Does anyone know if the DBA functions open the Sleepycat Berkeley DB is opened in Data Store or Concurrent Data Store mode? It doesn't seem to be documented. More generally, the Berkeley products look great - is there anyone with the skills and time to write a more complete API? Perl and Tcl seem to be well ahead here, which is a pity. It would be great if someone could put this right. Geoff Caplan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Managing value pairs - the best approach?
Hi folks I am looking for the lowest overhead approach to managing persistent session data. Our session class will be doing at least one read and write to the to the session table for every page view, so it will be pretty resource intensive if we don't get it right. MySQL is weak in read/write scenarios, and running Postgres just for this seems over the top, so I am looking for a better approach. The data will simply be a value pair - Key = session ID, Value = serialised data array. The Sleepycat Berkeley DB would seem to be a good way to go. An alternative approach would simply be to use the file system, with a seperate file for each record. But I suspect that this might break down once records hit the tens of thousands. Or is there some other approach I am missing? Any advice would be much appreciated Geoff Caplan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]