XTdb version 2.2!

[James Sentman]

Hi Folks,

A new build of XTdb is now available. This brings back the original auto ranging calculation which is the main draw. It also makes significant improvements in all the database maintenance functions which run many times faster than the did before and run in the background instead of blocking the UI and access to the other database items. The initial load can be many times faster too depending on the disk speed. i’ve had many bug fixes and things I knew that needed to be cleaned up in there and now it’s ready for all the graph system updates that we’ve been talking about so much lately.

as always you can get it from the wiki page at:

http://machomeautomation.com/doku.php/xtdb

	• Return to the original auto ranging calculation which works better.
	• Verifying and repairing the database now takes place in a separate thread. The program can continue to run normally during the regular database verify and if a unit needs to have it’s database rebuilt, only that one unit is temporarily disabled. All data points that are sent while the unit is offline are queued up and processed when the rebuild is complete.
	• Reaping old data out of the database is now also processed in a separate thread. Only the unit being worked on is temporarily disabled. All new datapoints for that unit will be processed as soon as the database maintenance is complete.
	• The duty cycle calculation now properly includes the time to the present if the unit is ON when the calculation is run.
	• The date selectors in the unit query window are now system standard and should always show time and date in the proper format for your system settings.
	• The unit query window is now loaded threaded, so you can begin to interact with it immediately while it’s still loading data. If you accidentally start a huge query there is also a cancel button to stop the background updating.
	• Fixed a bug in the unit query window that would leave off the very first unit event in the time frame you were interested in.
	• The initial loading of the program is now much faster.
	• All database maintenance functions, the scan, rebuild and reap, are several times faster than previous and no longer block the interface or the reception of new data or the generating of graphs or reports. Unless the specific unit database is the one being re-written in which case it will delay processing those requests.
	• The database window is now easier to get the toolbar popups for editing large selections of units to actually popup.
	• Errors and status updates are once again written to the XTension log.


This version does not make any changes to the database format. But it does have completely re-written maintenance routines and while I’ve rebuilt my database a dozen times and been running it here overnight that hardly consists as a full range of testing. I assume everyone is using at least time machine to backup their machines, but it wouldn’t be completely inappropriate to make a backup of the XTdb database folder. You’ll find it inside your users library folder and then inside the Preferences folder. I’ll be moving it to the application support folder in the next build or so as thats where such things are supposed to go now. You can get to that folder by using the “Go To Folder” menu in the Finder and entering ~/Library/Preferences/ and then just duplicating the XTdb Database folder. Then if something horrible happens you can just put it back.


Thanks,
 	James


James Sentman                       http://sentman.com		http://MacHomeAutomation.com