Subscribe to this list via RSS Blog posts tagged in Databases

Posted by on in Blogs
Static Analysis and Generated Code In recent months, I've been thinking about the problem of static analysis in generated code. Static analysis means using tools like FxCop and NDepend (for .NET apps) lint (for C) and CodeHealer (for Delphi) to find potential problems in your source code. Generated code is code written not by a human being, but by a tool, such as generated classes for a Entity Framework or LINQ to SQL model, an import for a COM type, or code created by a form generator. Static analysis is intended to find code w...

Posted by on in Blogs
Skip(0) in LINQ and Testing A couple of weeks ago, I wrote In LINQ, Beware of Skip(0). In that post, I observed that calling Skip(0) on a query result in LINQ, which has no effect on the dataset returned, imposes a performance penalty with at least some LINQ providers. At the time I commented that there might be some desirable behavior of this that I had missed. Sure enough, one of the developers on the LINQ to SQL team noted in comments that Skip(0) will cease to be a no-op in LINQ to SQL in .NET 4.0, and supplied a perfe...

Posted by on in Blogs
A Not-So-Secret Sale Upscene Productions is offering their Database Workbench Pro product for 75% off, through 28 March 2009 only. They call this the "Super Secret Sale," but since Martijn asked me to post it here, I'm not sure how much of a secret it is. Anyway, 75% off is about as cheap as you'll ever find it, so if you've been considering buying the tool, now is a good time. Database Workbench supports InterBase and many other DB servers. You can buy the module for one (or more) DB server only if you don't nee...

Posted by on in Blogs
All Access Embarcadero's DavidI and Mike Rozlog stopped by the Vertex Systems office on Wednesday to chat with us about Embarcadero's plans for the near future and David's personal developer wish list. They told us about the All Access product, which had been officially released that day. One of the most interesting things about this product is that it is installation-free, or so Embarcadero claims. It uses a virtualized registry, etc., so that you can just start the application directly. I'm thinking t...

Posted by on in Blogs
Data Structures for Time Records Over the years, I've had a number of occasions to need to store information about when somebody worked on a certain job. Sometimes people will want to store the date the work was done and the number of hours the employee worked, where as other people will need to store the start time and the stop time (in other words, when the employee "punched in," and when the employee "punched out"). Often, the same customer will need to use both methods of recording time, depending upon the nature of the wor...

Posted by on in Blogs
Database Workbench Lite for InterBase Martijn Tonies e-mailed me to inform me of the release of Database Workbench Lite for InterBase.  It's a free version of Database Workbench, a full-featured administration tool for InterBase and other database servers.  You can compare the "lite" and "professional" feature sets here. Upscene had also just released version 3.2 of Database Workbench Professional....

Posted by on in Blogs
Embarcadero The Embarcadero deal seems, from my outsider's point of view, to be a great deal for CodeGear and for Embarcadero. There are so many different ways that the two companies' products can work together that it just makes a great deal of sense to me. It's less clear to me how it makes sense for Borland, but that's their problem. I'm curious about one thing, though. Embarcadero is, at present, a database tools vendor. With their purchase of CodeGear, they are acquiring two fine databases: InterBa...

Posted by on in Blogs
Oracle and PHP Oracle and PHP can be a powerful combination to create strong and scalable server apps, the Oracle support in PHP is becoming better and better as Oracle itself is working on the OCI8 extension to improve it. If you are interested on this combination, you should check this blog to keep you informed: http://blogs.oracle.com/opal/  Just highlight the latest article which points to a customer interview on PHP and Oracle....
Tags: Databases PHP

Posted by on in Blogs
SQL-to-Code Macro OK, I'm not trying to steal Joe White's thunder here on Delphi macros, but when I plugged Joe's series, I mentioned that I use Delphi macros for converting SQL created in a query analysis tool into Delphi constants, and commenter Jack asked for more details on this. I thought it would make a better post than comment. The general idea is that we want to start with an SQL statement, like this: SELECT * FROM MY_TABLE; ...and turn it into a Delphi constant, like this: const My...

Posted by on in Blogs
PostgreSQL 8.3 Released PostgreSQL, after MySQL, is one of the choice databases to develop PHP applications, a new version has been released: "The release of the long-awaited PostgreSQL version 8.3 has been announced. The new feature list includes HOT, which dramatically improves performance for databases with high update activity; asynchronous commit; built-in full text search; large database features such as synchronized scans and reduced storage overhead; built-in SQL/XML support; spread checkpoints; and many more...
Tags: Databases

Check out more tips and tricks in this development video: