Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 8

Displaying posts with tag: derby (reset)

OpenSQLCamp 2009 presentation videos are online and free!
+4 Vote Up -0Vote Down

In record time, less than a week after the conference (thanks to the free Pinnacle Video Spin and YouTube), all 11 videos that were taken at OpenSQLCamp Europe are online.

For those who missed the sessions, or just want to relive the fun!

Almost all the sessions were filmed; regrettably Darren Cassar’s Securich – MySQL user administration and security made easy! and …

  [Read more...]
Golden Rules for Contribution-based Communities
Employee +0 Vote Up -0Vote Down

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. (I …

  [Read more...]
Golden Rules for Contribution-based Communities
Employee +0 Vote Up -0Vote Down

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. …

  [Read more...]
Golden Rules for Contribution-based Communities
Employee +0 Vote Up -0Vote Down

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. …

  [Read more...]
Open Source Database Poll
+0 Vote Up -0Vote Down

So Fred and I were wondering what people were planning to use as a Database the next couple of months / years or now.

We mostly see MySQL deployments and a little PostgreSQL

But there's other stuff around ..

So what are you using, , or planning on using ?

Vote Here !

Database Connection Node Changes
Employee +0 Vote Up -0Vote Down

Hi all,

As I mentioned in a previous blog entry, big changes are underway to the database connection connection node in NetBeans 7.0. If you look at the image above, you'll see what I mean. In the connection that is highlighted, no schema was selected when the connection was made, thus "default" is displayed as the schema.

When the schema is default, all schemas are displayed under the connection node when it is expanded. When you expand the schema, you'll see a familiar sight: the Tables, Views, and Procedures folders.

Individual database connections are also displayed as separate nodes below, even with default schemas.

Be sure to stay tuned for changes.

Happy Holidays!

--James

INFORMATION_SCHEMA Support in MySQL, PostgreSQL
+0 Vote Up -0Vote Down

I've known about the INFORMATION_SCHEMA views (or system tables) in SQL Server for a while, but I just leared recently that they are actually part of the SQL-92 standard and supported on other database platforms.

The INFORMATION_SCHEMA views provide meta data information about the tables, columns, and other parts of your database. Because the structure of these tables are standardized you can write SQL statements that work on various database platforms.

For example suppose you want to return a resultset with a list of all columns in a table called employees

SELECT table_name, column_name, is_nullable, data_type, …
  [Read more...]
Three Open Source Databases in Solaris SXDE 1/08
Employee +0 Vote Up -0Vote Down

 

These three open-source databases, now in OpenSolaris SXDE 1/08, offer all the needed features for most of the applications out there.

"Three databases to run them all"...

... and of course, Sun offers solutions with commercial database vendors, like the …


  [Read more...]
Showing entries 1 to 8

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.