You are here

Welcome to the NuoDB Blog

  • With NuoDB 2.0 the support for stored procedures gains a new exciting feature: the capability of running a procedure written in the Java language. Stored procedures written in SQL still achieve the maximum performance boost, but Java stored procedures have on their side a richer programming language, a huge number of third-party libraries and an almost effortless migration path from client-side code to server-side extension.

    In order to create a stored procedure backed by Java code, the developer must wrap the code in a static method having a suitable signature, compile it and

  • */ ]]]]> /*--> */

    You may already be familiar with Asterisk , the widely-deployed open-source telephony framework. If you aren't, you should check it out. It's a pretty cool piece of software. A low-load instance of Asterisk can be deployed to use the filesystem to store things like phone-registration data and voicemails. But if you want to do anything fancy with Asterisk, or if you happen to care about things like fault-tolerance, you might look at pointing Asterisk at a database. And if you happen to have a large Asterisk cluster built to handle

  • Today we released NuoDB 2.0, and if you've been following along you've seen a lot of discussion around automation. In our 1.2 release we provided a preview of where we're going, and with 2.0 we're building on those features to support starting and managing databases across multiple regions. We've also started collecting domain-wide statistics into a NuoDB database that you can use to monitor what's happening

    With today's release these new automation features are available, but not enabled by default. To turn them on

  • You may already be familiar with a tool called rlwrap . If you aren't, you should check it out. It's a nifty tool. On Unix-like systems, it provides readline functionality for commands that lack it. Our nuodbmgr is one such command. If you spend any time managing NuoDB domains in an ad-hoc fashion and you're a fan of the command-line, then you can make your life a little easier and save yourself some keystrokes. First, install rlwrap either

  • Writing complex SQL queries can be hard. As a declarative language SQL lets the database hide the actual implementation of queries from the user. It can become hard to see how and why one query performs better than others. As with most databases NuoDB has a "query explain" facility. The explain facility displays the query plan that NuoDB's optimizer produced for a query. The query plan shows what decisions the NuoDB optimizer made. With the plan in hand the user can make changes to the query or the database structure (add/remove indexes) to improve query performance.

    Explain is not

  • Company to conduct live product launch featuring customer’s geo-distributed database deployment

    Cambridge, MA – September 26, 2013 – NuoDB, Inc., the leader in NewSQL distributed database technology, announced they will be conducting a live-streamed webcast on October 16, 2013, to introduce NuoDB Blackbirds Release 2.0. The new release is a major enhancement of the company’s original release made generally available earlier this year.

    The new release offers over 200 new features and improvements over previous versions

  • Here in the NuoDB Engineering organization, we run pretty lean. One of the most important things we do as engineers is ensure that our features and bugfixes are well tested. The NuoSQL team uses a variety of techniques to build a testable and tested product.

    Test-Driven Development

    Test-driven development has become a buzzword, but it has always been a standard way of doing things in the programming language world. User stories are the rationale for a new language feature, and use cases are, by and large, immediately useful as test cases. For

  • In the first installment of this two part series we talked briefly about the benefits of running NuoDB as a database backend for nopCommerce. If you wanted more detail, or just to see it in action, I recommended watching the on-demand webinar “ Enabling Scalability & Redundancy in eCommerce .” Today, I’d like to introduce you to some of the details for how nopCommerce was enhanced to run on NuoDB, and to provide a peek under the covers of the “Next-Next-Next” installation.

  • The Definitive ANTLR 4 Reference

    Disclosure: I received a complimentary review copy of this book.

    I would have happily bought a copy, as I have bought copies of author Ter Parr's previous books, because he writes a different kind of "compiler" book. The Definitive ANTLR 4 Reference integrates two of Parr's previous lines of thinking; it's a great introduction to the ANTLR4 parser, but even more, it's an introduction to how to think like a real-world compiler writer.

    Compiler-Writing in the Real World

    How is being a real-life

  • The NuoSQL tool, nuosql, is the command line utility for accessing data in NuoDB. There is one new option as of NuoDB 1.2 that is very useful for displaying data with very wide columns using nuosql. Then there's another new option (but you'll have to wait for NuoDB 2.0) that is useful for displaying many rows of data.

    Displaying your data is a challenge when you have very long character strings in a column or new lines in a character string column. To demonstrate this, I created a table with the following schema:

    SQL> show table nuodb_friends Found table NUODB_FRIENDS in