http://database.web2announcer.com/ Web 2.0 announcer top stories for database en Thu, 24 Jul 2008 21:39:46 GMT http://web2announcer.com/go/2716473 unknown@DZone.com Have you heard of Drizzle? As detailed here, it's a lightweight, open source SQL database for the cloud and the web, being designed for massive concurrency on multi-CPU/core architecture. If that sounds a lot like MySQL, it should. Drizzle's code is derived from MySQL--basically a fork of the MySQL 6.0 source code. Thu, 24 Jul 2008 21:39:46 GMT http://web2announcer.com/go/2716473databaseNewsopen sourceProgramming http://web2announcer.com/go/2715607 unknown@DZone.com For the last 2-3 years, Brian Aker and I have had many discussions about how to refactor MySQL. Brian has been the one driving these discussions by asking why some things in MySQL were done in a certain way and in a true "what if" manner asked what would happen if we would do things in another way. Thu, 24 Jul 2008 13:07:56 GMT http://web2announcer.com/go/2715607announcementdatabaseserverweb designProgramming http://web2announcer.com/go/2715556 unknown@DZone.com If you are looking for an alternative for the traditional combination of Apache, PHP and MySQL, then this might be an option. The BitNami folks offer an all-in-one installer for Apache, PHP, PostgreSQL and the phpPgAdmin tool for Windows, Linux and OS X. Thu, 24 Jul 2008 12:48:22 GMT http://web2announcer.com/go/2715556databaseopen sourcephpserverProgramming http://web2announcer.com/go/2715201 unknown@DZone.com Both Talend (Java) and Kettle distribute the Zentus.com pure-Java SQLite JDBC driver and for most purposes this run-anywhere version is fine. But, if you really need to take advantage of SQLite’s speed then connecting using the native JNI version is a must. Doing this was easy enough, just change over to using a generic JDBC connection specifying the required native jar and placing the associated dll/so on your system path. Thu, 24 Jul 2008 08:36:01 GMT http://web2announcer.com/go/2715201databasejavaProgramming http://web2announcer.com/go/2714238 unknown@DZone.com Today Brian Aker announced a fork of MySQL, called "Drizzle". Drizzle is a slimmed-down MySQL, in a lot of ways what MySQL should have been before MySQL AB became more concerned about their deal with SAP than their core user base. Wed, 23 Jul 2008 19:49:28 GMT http://web2announcer.com/go/2714238databaseProgramming http://web2announcer.com/go/2713007 unknown@DZone.com I struggled setting up a project with Spring 2.5 and JPA (Hibernate3.2) and keeping it all annotation driven. Most of the examples were not related to my setup and the configuration is starting to get complex. So, here is mine, I hope it helps you. Wed, 23 Jul 2008 07:26:19 GMT http://web2announcer.com/go/2713007databaseframeworkshow-tojavaProgramming http://web2announcer.com/go/2711525 unknown@DZone.com Sometimes you may need to store complicated data with non-fixed fields/data types in table. There are different ways for that but if we use symfony where YML is so native and good known - why dont store data in table as YML-formed value. Tue, 22 Jul 2008 15:47:08 GMT http://web2announcer.com/go/2711525databasephpProgramming http://web2announcer.com/go/2711400 unknown@DZone.com A new SQL injection hack seems to be out in the wild from verynx.cn. The SQL Injection hack uses a CHAR array to hide its payload which will insert some various html garbage along with a reference to a javascript file on the verynx.cn domain that will infect users when they visit your website. Luckily the domain with the offending javascript file now points to 127.0.0.1 which will help stop the spread of the virus. Unfortunately the botnet still seems to be spamming websites with the scripted attack leaving many entirely broken or loading extremely slow as each page might have hundreds of requests to the payload. Tue, 22 Jul 2008 14:31:43 GMT http://web2announcer.com/go/2711400databaseProgramming http://web2announcer.com/go/2710983 unknown@DZone.com This is a request to all MySQL users to help mysql developers, by providing information, so that we can help you, by providing a more stable MySQL server for your needs. Tue, 22 Jul 2008 10:40:41 GMT http://web2announcer.com/go/2710983announcementdatabaseopen sourceserverProgramming http://web2announcer.com/go/2709753 unknown@DZone.com You can generate simple bar charts directly from a MySQL prompt. Here is an example. Mon, 21 Jul 2008 21:16:59 GMT http://web2announcer.com/go/2709753databasehow-toserverunix-linuxProgramming http://web2announcer.com/go/2709694 unknown@DZone.com The Network World blog A World of Bytes asks whether, given that the Postgres family of database management systems are more robust and feature-rich than MySQL, there's ever any reason to use MySQL instead. The answer boils down to "Using MySQL isn't always a disaster, but Postgres is commonly the better choice." Mon, 21 Jul 2008 20:27:55 GMT http://web2announcer.com/go/2709694databaseopen sourceProgramming http://web2announcer.com/go/2708469 unknown@DZone.com MySQL 5.1 was in RC stage for around 10 months now finally planned to be released as GA soon. As Monty Says MySQL 5.1.26 will be renamed as GA if no serious bugs are discovered. Mon, 21 Jul 2008 05:46:12 GMT http://web2announcer.com/go/2708469databaseProgramming http://web2announcer.com/go/2708206 unknown@DZone.com This week in the Database Programmer Blog we return to table design patterns with an essay on history tables. The basic premise of this blog is that good coding skills do not lead magically to good database skills -- you can only make optimal use of a database by understanding it on its own terms. There is a new essay each Monday, and there is a Complete Table of Contents and a List of Table Design Patterns. Mon, 21 Jul 2008 02:11:05 GMT http://web2announcer.com/go/2708206databaseProgramming http://web2announcer.com/go/2706119 unknown@DZone.com When I teach, I frequently discuss temporal based data sets - after all, that's a big piece of what data warehousing and BI is about - Data Over Time. But when examining the database engines ability to "retrieve" specific data sets as a snapshot in time, it seems there is a problem. There appears to be no "consistent" manner in which to retrieve these layers for use by the business. Sat, 19 Jul 2008 13:51:30 GMT http://web2announcer.com/go/2706119databaseProgramming http://web2announcer.com/go/2705741 unknown@DZone.com Back in February I wrote a blog post on SQL Injection that included an example of how a malicious user might inject into a character field even though ColdFusion escapes single quote marks. The attack involved other forms of escaping single quotes - and was effective against MySQL. This week I stumbled upon (more like a train wreck) an attack that is much more sophisticated - and also involves injection into a character field. I am told..... Sat, 19 Jul 2008 07:59:01 GMT http://web2announcer.com/go/2705741coldfusiondatabasephpserverProgramming http://web2announcer.com/go/2705297 unknown@DZone.com db4objects offers USD 6000 in prizes for the best patch submissions to make the object database engine "db4o" faster. Sat, 19 Jul 2008 01:55:53 GMT http://web2announcer.com/go/2705297databaseopen sourceProgramming http://web2announcer.com/go/2704482 unknown@DZone.com Now that MySQL has decided to ready the final Release Candidate (RC) for version 5.1 instead of moving forward with a General Availability (GA) release and Michael Widenius has extended an bug filing call to its user community. Fri, 18 Jul 2008 15:16:09 GMT http://web2announcer.com/go/2704482databaseopinionProgramming http://web2announcer.com/go/2702388 unknown@DZone.com SQLite is a very interesting database engine. Its performance, simplicity and that fact it runs as a library (not a server) make it the perfect candidate for small project with few users.
 
 Today I experimented with accessing SQLite database from within groovy. Thu, 17 Jul 2008 14:01:00 GMT http://web2announcer.com/go/2702388databasegroovyProgramming http://web2announcer.com/go/2700435 unknown@DZone.com People who are used to relational databases, which is pretty much every gosh-darned web developer out there, will run into pretty much the same obstacles with the app engine datastore - one of them is How the heck do I do SUM or AVG?. This a guide how to do it. Wed, 16 Jul 2008 16:52:07 GMT http://web2announcer.com/go/2700435databasehow-topythonProgramming http://web2announcer.com/go/2699691 unknown@DZone.com My latest blog post shares a technique I've used to create a Grails application with a dynamic, runtime switchable datasource. Wed, 16 Jul 2008 08:06:05 GMT http://web2announcer.com/go/2699691databasegroovyhow-toopen sourceProgramming http://web2announcer.com/go/2698418 unknown@DZone.com Don't let the old object-relational impedance mismatch get the best of you or your data. Compare ORM tools Hibernate and iBATIS and the Java Persistence API itself, and find out how each one makes it easier to access your RDBMS using Java code. Tue, 15 Jul 2008 18:54:25 GMT http://web2announcer.com/go/2698418databaseframeworksjavaopen sourceProgramming http://web2announcer.com/go/2697903 unknown@DZone.com Parleys.com has posted some excellent videos for anyone wanting more info on the Java Persistence Framework. The videos are geared for people who have at least had some exposure to JPA programming. Also, the videos use some persistence annotations (e.g. @PersistenceContext) so it's helpful if you've already seen those before and are at least familiar with the concept of session beans. Tue, 15 Jul 2008 14:04:07 GMT http://web2announcer.com/go/2697903databaseframeworksjavaProgramming http://web2announcer.com/go/2697786 unknown@DZone.com This article shows how to use the LPAD/RPAD functions to pad the left-side or right-side of a string with a specific set of characters in the Oracle PL/SQL. Tue, 15 Jul 2008 13:10:19 GMT http://web2announcer.com/go/2697786databasehow-toProgramming http://web2announcer.com/go/2697633 unknown@DZone.com One of the items we're struggling with now on Stack Overflow is how to maintain near-instantaneous performance levels in a relational database as the amount of data increases. More specifically, how to scale our tagging system. Traditional database design principles tell you that well-designed databases are always normalized, but I'm not so sure. Tue, 15 Jul 2008 11:20:39 GMT http://web2announcer.com/go/2697633databaseProgramming http://web2announcer.com/go/2697192 unknown@DZone.com For the last couple of weeks I’ve been playing with Google App Engine.
 
 In case you’ve been living in a cave for the last month; App Engine is a mostly complete, sandboxed, Python 2.5 environment with a WSGI web server and a very interesting Datastore API. Tue, 15 Jul 2008 05:59:15 GMT http://web2announcer.com/go/2697192databaseframeworkspythonProgramming http://web2announcer.com/go/2696651 unknown@DZone.com Although some people may be aware that SQLite supports Full-Text Search (FTS) I would guess that not many have much experience with getting it setup and using it. I only base this information on the fact that the documentation on the SQLite site as well as what I could find on the Googles has been pretty slim. As a result I thought it might would to provide a walkthrough on getting SQLite FTS setup and working. That said I must preface this by saying that the instructions here apply specifically to Mac OS X. Tue, 15 Jul 2008 00:08:10 GMT http://web2announcer.com/go/2696651databaseProgramming http://web2announcer.com/go/2696112 unknown@DZone.com Rails 2.1 introduces three annoying bugs. Let's fix them. Mon, 14 Jul 2008 19:34:38 GMT http://web2announcer.com/go/2696112databaseframeworksrubyweb 2.0Programming http://web2announcer.com/go/2695634 unknown@DZone.com MySQL 5.1.26-RC has been released today and is slated to be the last release candidate before we declare MySQL 5.1 as "production ready" (GA). We therefore appreciate any feedback and community testing of this release, to ensure that we have ironed out any remaining critical issues. Mon, 14 Jul 2008 14:55:47 GMT http://web2announcer.com/go/2695634announcementdatabaseopen sourceserverProgramming http://web2announcer.com/go/2695100 unknown@DZone.com working with nested sets and zend framework Mon, 14 Jul 2008 09:59:28 GMT http://web2announcer.com/go/2695100databasehow-tophpProgramming http://web2announcer.com/go/2694991 unknown@DZone.com Speed and efficiency are key factors when running a website. All code needs to be optimized, whether it is PHP, ASP, Python, or SQL. This post provides a speed comparison between the "IN" and "OR" statements of SQL. Mon, 14 Jul 2008 08:34:01 GMT http://web2announcer.com/go/2694991databaseresearchweb designProgramming http://web2announcer.com/go/2693550 unknown@DZone.com I spent significant parts of the last two weeks dealing with embedded databases. I have used, SQL CE, SQLite, FireBird, db4o and Berkeley DB. My requirements were really simple, or so I thought. I just wanted safe for multi threading and support for transactions. Sun, 13 Jul 2008 12:12:08 GMT http://web2announcer.com/go/2693550databaseresearchreviewsProgramming http://web2announcer.com/go/2692448 unknown@DZone.com Just a few notes on setting up Grails with PostgreSQL and PostgreSQL accounts for JDBC connections. Sat, 12 Jul 2008 18:42:28 GMT http://web2announcer.com/go/2692448databaseframeworksgroovyProgramming http://web2announcer.com/go/2690860 unknown@DZone.com Oracle SQL Developer is a free graphical tool for database development. The initial release, in March 2006, provided users with a graphical interface to interact with database objects by providing the ability to browse the database, run SQL, PL/SQL and SQL*Plus statements, execute SQL scripts, and edit and debug PL/SQL statements. This initial release also provide a suite of reports to further interrogate the dictionary. SQL Developer 1.0 was quickly followed by 2 patch releases and the SQL Developer 1.1 in December 2006. Sat, 12 Jul 2008 00:41:12 GMT http://web2announcer.com/go/2690860databasetoolsProgramming http://web2announcer.com/go/2689562 unknown@DZone.com Oracle Database 11g and the Symfony Web PHP Framework can make beautiful music together, as illustrated by this simple sample app. Fri, 11 Jul 2008 12:29:16 GMT http://web2announcer.com/go/2689562databaseframeworksphpProgramming http://web2announcer.com/go/2688956 unknown@DZone.com A funny anti-pattern that is found in the official Oracle PL/SQL User's Guide and Reference. Worst exception handling EVER. Fri, 11 Jul 2008 06:33:00 GMT http://web2announcer.com/go/2688956databasehumoropinionother languagesProgramming http://web2announcer.com/go/2687516 unknown@DZone.com For me the visualization of table relations is quite important, besides the table attributes. There are a lot of entity relationship modeling tools out there, doing a pretty good job. But, most of them are also quite expensive. I did a search for something OpenSource and found some tools from the mySQL community. Thu, 10 Jul 2008 15:28:56 GMT http://web2announcer.com/go/2687516databaseopen sourcetoolsProgramming http://web2announcer.com/go/2687395 unknown@DZone.com The title of Peter’s inquiry is somewhat misleading, as the database itself works fine. He clarifies a bit with, “there suppose to be 2 yearly binary releases (which are overdue) and 4 predictable yearly source releases, which we have not seen either.” I thought it was clear that “2 per year” doesn’t mean “one every six months”. It’s been eight months, sure. And I don’t actually believe that MySQL is going to have one source release per month until November, to make up for the lack of source releases. However, it’s certainly possible, if not probable. Thu, 10 Jul 2008 14:15:08 GMT http://web2announcer.com/go/2687395databaseopinionProgramming http://web2announcer.com/go/2687069 unknown@DZone.com Not be out done, here are the 101 LINQ Samples for C#. The interesting thing for someone like myself who has done both VB.NET (actually from VB DOS to VB.NET 2003) and having done mostly C# recently (last 4 years), is the approach that the Visual Basic and C# Teams took. I prefer the VB.NET way of doing things (I guess I am still biased towards the more Verbose/English-like Syntax of VB.NET over the more terse C# Syntax). Either way, the good news is that you can get the job done in either .NET Language, and I am assuming that you'll also be able to do LINQ in IronPython (PHP for .NET), IronRuby (Ruby on .NET), COBOL.NET, and all of the other .NET Languages. Thu, 10 Jul 2008 11:22:04 GMT http://web2announcer.com/go/2687069.netdatabasehow-toMicrosoftProgramming http://web2announcer.com/go/2684563 unknown@DZone.com Google has open-sourced its protocol buffers, the company's lingua franca for encoding various types of data, in order to set the stage for a wave of new releases, according to official company blog posts and documents. Wed, 09 Jul 2008 10:59:16 GMT http://web2announcer.com/go/2684563databaseNewsopen sourceother languagesProgramming http://web2announcer.com/go/2684056 unknown@DZone.com This article explores how we could achieve persistence ignorance for business object with ActiveRecord using a repository. Wed, 09 Jul 2008 06:29:57 GMT http://web2announcer.com/go/2684056.netdatabaseframeworksMicrosoftProgramming http://web2announcer.com/go/2682147 unknown@DZone.com Many database performance decisions come down to "pay me now or pay me later." Some decisions will produce faster inserts and updates at the cost of slower and more complex reads, while other decisions will slow down inserts and updates but provide faster and easier reads. Tue, 08 Jul 2008 11:54:09 GMT http://web2announcer.com/go/2682147databaseMicrosoftProgramming http://web2announcer.com/go/2681817 unknown@DZone.com Microsoft has just released a free utility to help developers analyze ASP code for SQL Injection vulnerabilities. Earlier this year, several public sites went down when hackers unleashed a series of bots to find and exploit servers where developers did not correctly code their applications/pages to prevent SQL Injection attacks. Tue, 08 Jul 2008 08:22:55 GMT http://web2announcer.com/go/2681817databaseMicrosoftSecurityserverProgramming http://web2announcer.com/go/2681787 unknown@DZone.com jLynx, with version 1.5.1, gets even simpler now with YAML configuration to replace XML configuration. In a nutshell jLynx is a simple, lite, hi-performance layer over the JDBC API. Persist and retrieve POJO and Map objects directly. Designed for developer productivity, it is simpler, easier to deploy as compared to Hibernate, JPA, etc. The project is hosted at Google Code. Tue, 08 Jul 2008 08:13:23 GMT http://web2announcer.com/go/2681787ajaxdatabasejavaopen sourceProgramming http://web2announcer.com/go/2681788 unknown@DZone.com I give this information from my pratical experience and therefore, this info may not follow the conventional apache-mysql tuning. These all tips are effective, as per my concern. Tue, 08 Jul 2008 07:48:06 GMT http://web2announcer.com/go/2681788databaseopen sourceserverunix-linuxProgramming http://web2announcer.com/go/2681791 unknown@DZone.com This is an article on how to use temporary table variable and structures in SQL server. Tue, 08 Jul 2008 07:47:14 GMT http://web2announcer.com/go/2681791databasehow-toMicrosoftProgramming http://web2announcer.com/go/2680406 unknown@DZone.com This article demonstrates how to use Oracle OCI functions to access Oracle database in C++. Mon, 07 Jul 2008 16:41:06 GMT http://web2announcer.com/go/2680406c-and-cppdatabasehow-toProgramming http://web2announcer.com/go/2679405 unknown@DZone.com This is a nice example of how to use the form-building service by Wufoo. Sun, 06 Jul 2008 21:15:30 GMT http://web2announcer.com/go/2679405databasehow-tophpweb designProgramming http://web2announcer.com/go/2679408 unknown@DZone.com How do you handle a massive number of fulltext searches? MySQL? Been there, done that. It’s a no-go for average servers. PostgreSql with Tsearch2?
 See a nice solution cooked from ruby, thin, memcached and sphinx. Sun, 06 Jul 2008 20:17:51 GMT http://web2announcer.com/go/2679408databaseframeworksrubyProgramming http://web2announcer.com/go/2679409 unknown@DZone.com So I’ve been fiddling around with CouchDB lately. Since it’s common to store tree-based data, and it’s kind of a pain to do so in your standard relational DB, I thought it would be a good exercise to see how hard it is to store hierarchical data in CouchDB. Sun, 06 Jul 2008 20:16:30 GMT http://web2announcer.com/go/2679409databasepythonProgramming http://web2announcer.com/go/2678793 unknown@DZone.com The PostgreSQL community is getting really serious about replication. On Thursday May 29th, Tom Lane issued a manifesto concerning databas replication on behalf of the PostgreSQL core team to the pgsql-hackers mailing list. Tom's post basically said that lack of easy-to-use, built-in replication is a significant obstacle to wider adoption of PostgreSQL and proposed a technical solution based on log shipping, which is already a well-developed and useful feature. Sat, 05 Jul 2008 20:02:44 GMT http://web2announcer.com/go/2678793databaseProgramming