RSS

Monthly Archives: December 2011

Introduction to Stored Procedures Part Two

In Part One of this series we got to see some simple examples of M code being used as Stored Procedures from Java. We saw that how Stored Procedures are named and how to use the name to call it from Java or from the M command prompt.

Part two will cover a deeper example that involves storing and reading data in a M Global – similar to how you may end up using the Stored Procedures feature your applications. In the process we’ll cover in more detail how to write the M code, how to declare the procedure in dcSchema, how to call from Java and how to process the return values.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in DivConq, Framework, MUMPS

Comments Off

DivConq Framework 0.4.5 Released

Today we released DivConq Framework 0.4.5 to introduce “dcTables” a new feature which supplements the benefits of stored procedures. Download.

As you know, the main purpose of our open-source DivConq Framework is to let Java developers quickly harness the power of MUMPS-compatible “NoSQL” databases. To fully harness that power you need to code stored procedures in MUMPS. But sometimes you just need something *like* a relational table, and why should you have to code that?

At DivConq we say you can have your cake and eat it too. With dcDb you get the power, flexibility and speed of NoSQL when coding stored procedures in MUMPS. But, with dcTables you get the rapid development and ease of use of relational databases too. Furthermore, all your data – dcDb and dcTables – can reside in one database. Easy to administer (setup, backup and restore) and very helpful for developers. Your stored procedures can access not only your NoSQL (dcDb) data but also your dcTables data – all in the same routine using only standard MUMPS commands. For those occasions when data in NoSQL refers to data dcTables (or vice versa) nothing beats the convenience and speed of having all your data in one place.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in DivConq, Framework, MUMPS

Comments Off

Speeding up SSH Login

Anyone who has tried connecting to M using the DivConq Database Connector may have noticed a long wait (5+ seconds) during the initial connection. This is caused the SSH protocol and configuration. If you are a developer you probably hate waiting for this delay each time you run debug. There is a way to reduce that delay by disabling DNS in your server’s SSH config. All this does is stop the SSH server from doing a reverse lookup on your ip address for logging. So if you don’t care about that then try this config tip.

Edit /etc/ssh/sshd_config on the server and add (or replace) the DNS option so it looks like “UseDNS no”. Restart the SSH daemon with “service ssh restart” or equivalent. If your problems stem from DNS then your login time should go down considerably. If that doesn’t help check out the SSH FAQ.

 

Posted by on 2011-Dec-12 in Uncategorized

Comments Off

Introduction to M (MUMPS) Part 4

In part one of this series I presented a summary of how the DivConq database connector for M (MUMPS) will work. Then we covered how to install M (GT.M software) and how to get to the M prompt.

In part two of this series I presented a review of the basics of the M programming language.

In part three of this series we examined how data is persisted in M why the M programming language is well suited to data access.

In this fourth and final part we’ll finish up some of finer points of M.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in Framework, MUMPS

Comments Off

Introduction to Stored Procedures Part One

In this series we’ll review how to write stored procedures, both for querying data and for updating data. We’ll be using the stored procedures from the dcTest Package mentioned in the previous post on getting connected.

To follow this post you’ll need to have DivConq downloaded and configured, see Getting Connected with DivConq. You’ll also need a working knowledge of M, at least the concepts covered up through Introduction to MUMPS part 3.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in DivConq, Framework, MUMPS

Comments Off

Getting Connected With DivConq

The main purpose of our open-source DivConq Framework is to let Java developers quickly harness the power of MUMPS-compatible “NoSQL” databases. The real power of MUMPS comes not just from its flexible data structures, but in a large part from its stored procedures. To that end, DivConq Framework provides a reasonably easy and intuitive approach to utilize MUMPS stored procedures.

In the MUMPS world the stored procedures are call MUMPS routines, but for those coming from a SQL background just think “rich language for stored procedure coding”. MUMPS (M) has a rich ability for working with data structures not often found in SQL or NoSQL solutions. To learn more about coding MUMPS routines look to our Introduction to MUMPS series on this site.

This post will guide you through setting up your M and Java environments and testing connectivity.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in DivConq, Elastic Architecture, Framework, MUMPS

Comments Off

Introduction To M (MUMPS) Part 3

In part one of this series I presented a summary of how the DivConq database connector for M (MUMPS) will work. Then we covered how to install M (GT.M software) and how to get to the M prompt.

In part two of this series I presented a review of the basics of the M programming language.

In this third part we’ll examine how data is persisted in M why the M programming language is well suited to data access.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in DivConq, Framework, MUMPS

Comments Off

Introduction To M (MUMPS) Part 2

In part one of this series I presented a summary of how the DivConq database connector for M (MUMPS) will work. Then we covered how to install M (GT.M software) and how to get to the M prompt.

In this second part we’ll review the very basics of the M programming language. We will do so from a M programmers point of view (I have 9 years of experience) but be gentle on some of the more dense M syntax and I’ll also avoid some of the confusing terminology. A very good place to get additional details about M is from the programmer guide on the GT.M website.

Read the rest of this entry »

 

Posted by on 2011-Dec-12 in Framework, MUMPS, nosql

Comments Off