Sql-server – From SQL Server to NuoDB: Common Table Expressions, Stored Procedures and Bulk Uploads

ctesql serverstored-procedures

I am currently evaluating NuoDB as a replacement for SQL Server. The application is written in C#, .NET 4.0.

Now I am using features of SQL Server like:

  • Common Table Expressions (I have a table with a reference to itself composing a n-level parent-chilren hierarchy)
  • Stored Procedures
  • Bulk Uploads

I didn't find enough reference on NuoDB to understand if it is suitable to do these things:

  • Large select operations with hierarchy logics (now I use a recursive CTE on the 'items' table to accomplish this)
  • Complex updates/inserts thru some kind of algorithm (stored procs would be ok)
  • Bulk insert/update of 100.000+ elements (I am using bulk upload feature of SQL Server .NET client and it works ok)

Besides this, I am also interested in partitioning, anybody has some experience in partitioning with NuoDB?

Thanks

Best Answer

The manual for CREATE PROCEDURE states: "Not Yet Implemented"

The documentation of the SELECT statement neither shows a WITH nor an alternative like connect by (as e.g. Cubrid does).

For bulkloading there is nuoloader but there doesn't seem to be an API for it.

But you will probably get a better answer if you post directly to the NuoDB forum: http://www.nuodb.com/community/forum.php?

I had a look at NuoDB as well and was pretty disappointed by the lack of SQL features. I guess that's not their main focus right now.

Related Question