21 Jan 2005
SYDI – Simplifying Network Documentation
SYDI is a very cool set of scripts that allow a network administrator to easily put together a series of documents about the various (windows) PC’s on his
network. I haven’t yet used it in the office, because (1)I’m a developer and don’t have time to deal with more than the bare minimum of system administrat
or tasks and (2)I run linux.
Anyways, I just ran it on the couple of windows PC’s on my home network and it generated nice Word reports. It’s worth checking out if you have this sort
of requirement. I know we had to go through a network documentation phase as part of our investors due dilligence process and this type of script would h
ave made it substantially smoother.
-
SYDI is a collection of Vbscripts to help people get started with the documentation process. What it can do is to collect information from a Windows Server
(SYDI-Server) or a MS SQL Server (SYDI-SQL) and present its findings in a MS Word document. This way the process isnt so boring since a lot of information
is gathered for you, another way it helps you is that you are given a general document which gives you an idea of what could be included in your server do
cumentation. If you feel like you dont need everything the scripts collect there are parameters which decide what goes into the word document. So if you li
ke the output but dont need a particular section, like printers or services you can easily remove them. SYDI has been tested with Windows 2000 and higher,
Word 2000 and higher, SQL 7.0 and higher.
*
21 Jan 2005
I’m sure you’re all aware that PostgreSQL 8.0 was release a couple days ago and a notable (and long awaited feature) was native support for windows.
I’ve yet to really put it through its paces on Windows, but I was impressed with the ease of install. Nothing out of the ordinary, just straight forward,
(almost) no questions asked installation.
**
Whats New:**
Savepoints
Savepoints allow specific parts of a transaction to be aborted without affecting the remainder of the transaction. Prior releases had no such capabilit
y; there was no way to recover from a statement failure within a transaction except by aborting the whole transaction. This feature is valuable for applica
tion writers who require error recovery within a complex transaction.
Important for SQL conformance. I don’t really write the kind of applications that require DB-level save points. I’m usually abstracted by CMP in JBoss an
d Hibernate for offline processes.
Point-In-Time Recovery
*
Though PostgreSQL is very reliable, in previous releases there was no way to recover from disk drive failure except to restore from a previous backup or us
e a standby replication server. Point-in-time recovery allows continuous backup of the server. You can recover either to the point of failure or to some tr
ansaction in the past.*
I’ve been happy with PostgreSQL’s reliability since we started using it as one of our supported JDBC data sources.
The lack of point in time recovery capabilities was not a significant drawback but improved restoration is welcome.
Tablespaces
Tablespaces allow administrators to select the file systems used for storage of tables, indexes, and entire databases. This improves performance and co
ntrol over disk space usage. Prior releases used initlocation and manual symlink management for such tasks.
Important for deployment into enterprise environments.
**Improved Buffer Management, CHECKPOINT, VACUUM
This release has a more intelligent buffer replacement strategy, which will make better use of available shared buffers and improve performance. The pe
rformance impact of vacuum and checkpoints is also lessened.
Performance improvements are always welcome.
Change Column Types
A column’s data type can now be changed with ALTER TABLE.
Sure, I guess its important but not the kind of thing I routinely do.
New Perl Server-Side Language
A new version of the plperl server-side language now supports a persistent shared storage area, triggers, returning records and arrays of records, and
SPI calls to access the database.
This is an interesting improvement. To date we’ve really stayed away from using DB-specific stored procedures and whatnot. I don’t think that the plperl
additions are going to do anything to change this, but they’re something I might play around with in whatever spare time I can find.
Comma-separated-value (CSV) support in COPY
COPY can now read and write comma-separated-value files. It has the flexibility to interpret non-standard quoting and separation characters too.
Meh, not overly important to me.
All in all, I’m primarily concerned with performance. I realize its not Oracle and nor do I expect it to be. PostgreSQL is an entry-level database but w
e have had good success with it to date. It does have a fairly decent feature set and sql compatibility compared with its direct competitors. First and f
oremost, I welcome any and all performance improvements. The support for the windows platform should expose a few more people to the database who previous
ly avoided it (because of the extra steps involved in setup, cygwin…etc) and went with MySQL.
20 Jan 2005
techno.blog(“Dion”): Internal A
mazon Developer Conference
It would be nice to work for a large enough company with the resources to make something like this happen. It’s nice to go to a conference and all, but i
f you can have some of the speakers come to you, it’s far less hassle.
Over the past few days, Amazon invited a group of fairly reknowned speakers to come and speak with their developers on topics ranging from AOP to Halo 2.
I have not yet read through all the speakers notes but from the couple I have, it looked to be a set of fairly interesting sessions.
Dion Almaer has provided links to the speakers notes on the Amazon Web Services Blog.