Kristian Waagan (of Sun's Java DB development team) has really given Java DB (Sun's distribution of Apache / Derby) a new life of its own when it comes to handling CLOBs, starting with Java DB 10.5.
Check out this thread.
Note the following testimony from David Goulden:
The performance improvements with CLOBs are
dramatic. I created a record with a CLOB containing about 10 million...
on May 28, 2009
Apache/Derby 10.5 is about to be released, and Knut Anders Hatlen has written a great blog entry about one of the new features: Generated Columns. (Knut himself has also worked on some important core-level feature that improves locking mechanisms within Derby.)
Derby is an all-Java database to which Sun engineers in the Java DB team contribute.
Java DB is Sun's release of Apache/Derby!
on Apr 16, 2009
Giri, has done a very nice job creating a tutorial on using MySQL Connector/C++.
This Connector is modeled after JDBC making it very easy to access MySQL using C++.
on Apr 15, 2009
A February 2009 eWeek article, Sun Microsystems Discusses Changes Afoot for MySQL Database, talks about the current status and future plans for the open-source database Sun acquired about a year ago. A recent reorganization has combined the software infrastructure group with the database group at Sun under VP Karen Tegan Padir, who says the new structure aims at delivering "open platforms for...
on Mar 23, 2009
Here is a screencast about MySQL for Developers
If you are a developer using MySQL, you should learn enough to take
advantage of its strengths, because having an understanding of the
database can help you develop better-performing applications. This
session will talk about MySQL database design and SQL tuning for
developers. Some topics include:
on Mar 18, 2009
MySQL Conference and Expo is coming up to Santa Clara this April.
The program schedule is really easy to navigate and tells you about everything there's to partake of.
A quick review will show you that the quality of the no-nonsense presentations will be amazing. (We should thank the MySQL community team for helping ensure a high level of quality and relevance.)
on Feb 2, 2009
MySQL 5.1 and MySQL 5.1 Connector/J 5.1 have been officially released. Connector/J 5.1 adds support for JDBC 4.0. You can download Connector/J and find out additional info regarding JDBC 4.0 support here.
on Dec 8, 2008
Check out Knut Anders Hatlen's blog on how to specify your own collator allowing you to have more control over the ordering of data in Apache Derby and Java DB.
on Dec 5, 2008
With a simple fix, Rick Hillegas has ensured that developers can have access to a powerful SQL parser that comes with Apache/Derby. (Sun's Java DB is a distribution of Apache/Derby that is available in the JDK, starting with JDK 6.)
on Nov 23, 2008
Knut Anders Hatlen writes about memcached user-defined functions (UDF) for Java DB on OpenSolaris.
Knut has also mentioned the recent release of Apache Derby 10.4.2. A corresponding Java DB release should be available for download soon. (Usually this happens immediately but we're all at a developers' conference for the next couple of weeks.)
on Sep 11, 2008
Speaker, Paul McCullaghBlobstreaming.org
This session explained why BLOB streaming may be relevant to your project, and how you can get started streaming BLOBs.
For ordinary types of data, MySQL sends the buffer from the client to the server. Streaming
involves making a connection from the source to the destination
continuously, storing and streaming simultaneously. But BLOBs are not ordinary...
on Apr 17, 2008
For those living in the Silicon Valley and working on software for the Web, one of the best technology conferences of the year will arrive literally around the corner: MySQL Conference & Expo, April 14 to 17, 2008, here in Santa Clara California.
on Apr 3, 2008
Let's say I have tones of named queries through all my entities. These queries have one/two or more named parameters in conditional expression.
The common way to encapsulate my named query lookup in my JPADAO is something like this:
Query q = %getEntityManager()%.createNamedQuery( %queryName% );
q.setParameter ("someParam", new Date ());
q.setParameter ("anotherParam", true);
on Jan 22, 2008
Josh Berkus covers the basics of PostgreSQL on Solaris in his Sun Tech Days, Milan, presentation.
on Dec 3, 2007
While I was away for meetings at Sun Microsystems's India Engineering Center, Eileen Alan of SDN channel posted a recent conversation I had with Kuldip Oberoi about Java DB and Apache Derby. I think Kuldip and I touched on a number of important topics about the technology, the business and Sun's general strategy behind Sun's Java DB work, and it is certainly very exciting to see the uptake by the...
on Nov 30, 2007
OK, native queries in JPA. Not really well documented. Of course I understand that we really should not be doing that, but hey there are times where it is just plain easier.
The following code snippet goes after an Oracle sequence and gets the value.
EntityManager em = this.getEntityManager();Query query = em.createNativeQuery("SELECT BLOG_ITEM_SEQ.nextval FROM DUAL");Vector blogItemRow...
on Aug 22, 2007
Randal Schwartz and Leo Laporte talk to Josh Berkus on FLOSS, about PostgreSQL, Perl, Python, PHP, Java, etc., and various PostgreSQL related projects.
on Aug 20, 2007
Learn more about PostgreSQL on Solaris from Zdenek Kotala.
on Aug 16, 2007
Check out this result to understand how you can save tons of money using PostgreSQL on Solaris on ULtraSparc T1 CoolThreads Server!
Very similar performance at a fraction of the cost!
(Licensing fees ==> Oracle on HP: $80,000. PostgreSQL on SunFire: $0.)
on Aug 16, 2007