I’ve recently been looking into NoSQL databases and found this
poll over at
JavaLobby.
According to the poll, the top 3 NoSQL databases are:
- Apache Cassandra - 33%
- Apache CouchDB - 21%
- MongoDB - 15%
Out of these top 3, MongoDB seems to be the one that most fits my needs. Its a scalable document centric database that has a simple Java API. Getting up and running with MongoDB is a very simple process and to easy to start writing apps against it.
If I had time to spend looking at Cassandra and CouchDB, I’d probably find them very similar, but for the moment I’m concentrating on MongoDB.
I’d be interested in others thoughts about these 3 NoSQL databases (or indeed any other NoSQL database).
The
Data Platform Insider blog details how Microsoft have announced the first CTP of the SQL Server Migration Assistant for MySQL which can be downloaded from the Microsoft Web site. The toolkit works with MySQL 4.1, 5.0 and 5.1
“Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure. SSMA 2008 for MySQL v1.0 CTP1 provides an assessment of migration efforts as well as automates schema and data migration.”
Thanks to Paul Thurott for the
original link.
In Oracle, the default page and line size settings for SQLPlus are 14 lines per page and 80 characters per line respectively. This can make viewing large result sets difficult when using SQLPLus.
Fortunately, these settings can easily be changed using the SET command:
set linesize 1000
set pagesize 1000
Executing these commands however only changes the settings for the current instance of SQLPlus. The next time you run it, the values default back to their original values. If these settings are placed in a file calledlogin.sql in the current working directory however, they will be loaded when SQLPlus starts.
RSS Feed