Planet MySQL

+2

-0

posted by Anders Karlsson on Mon 27 May 2013 17:07 UTC
Tags:

(edit) mariadb, json

I have patched up a MariaDB version with JSON support, just for the fun of it. This is not the best version of MariaDB around, as I am not a MariaDB developer by any means, and although I have played with the MySQL and MariaDB sources before, I have never attemped to look like I know it in detail. So although this works, it's probably full of memory leaks, errors and bad code (my additions, that is).

That said, it actually works. Surprise! For a simple prototype, that is to show off a specific feature.

So, this is what I have: I grabbed MariaDB 10.0.2 sources and worked from there. To support the JSON specifics, I included the Jansson C-library for JSON. So far so good, then I wanted a JSON datatype, that was the first step. Adding a new datatype to MariaDB / MySQL is a pretty major

[Read more...]

SQL and JSON, what do you think?

+1

-0

posted by Anders Karlsson on Sun 26 May 2013 18:50 UTC
Tags:

(edit) mysql, json, maruadb

As you might know, I'm a big fan of JSON. One big reason is that I believe that JSON is closer to most developers view on data, whereas the Relational SQL based model is closer to what someone working with data itself or someone working with infrastructure. What I mean here is that neither view is wrong, but they are different.

So, given that, can we merge the Object JSON world with the relational model? Well, not JSON, but Hibernate does it quite well. This is one of my objects to the NoSQL world, that the datamodel is closely linked to the application at hand, and less so to data itself and to other applications. Stuff such as accounts, privileges, accounting data, orders and many other things are global, and are not specifically connected a specific application, but in many NoSQL applications, this is what it ends up being.

And there are not

[Read more...]

What's the deal with NoSQL?

+0

-0

posted by Anders Karlsson on Sun 19 May 2013 18:49 UTC
Tags:

(edit) mysql, mariadb, json

Everybody seems to be looking at and debating NoSQL these days, and so am I and I thought I'd say a few words about it. Which is not to say I haven't said stuff before, bit them I was mainly targeting specific attributes of many NoSQL solutions (like "eventual consistency" or, as you might call it, "instant inconsistency", What I was opposing is that "eventual consistency" has anything to do with just that, consistency. Rather, what this means is that at any point in time the system is inconsistent, and even if it might be consistent, you cannot rely on it being so. Which is fine, but don't call it consistency, call it inconsistency. Allowing a database to be somewhat inconsistent doesn't necessarily mean that it's something wrong with it).

All this said, what is going on here, why are we MySQL and MariaDB users seeing so many

[Read more...]

Version 1.6 of mysqljsonimport now available

+0

-0

posted by Anders Karlsson on Mon 13 May 2013 17:00 UTC
Tags:

(edit) mysql, mariadb, json

Yes, finally! This took some time, but I have been so busy with other things, work-related as well as domestic, that I just haven't had the time for this. But finally version 1.6 is available for download from sourceforge. The downloads is as usual the autoconf enabled source code and PDF documentation in PDF.

So, what is new you ask, well there is one big new feature which took a lot more effort than I expected. When this program was written at first, I still have the table/use use in mind. What this means is that I visioned JSON objects to be mapped to a table. This is not how programmers view JSON, but this is how data is viewed in many databases, even NoSQL ones such as MongoDB. So I wanted an import tool for simple row-structured JSON

[Read more...]

JSON with MariaDB and MySQL Slides available

+0

-0

posted by Anders Karlsson on Tue 30 Apr 2013 21:46 UTC
Tags:

(edit) mysql, slides, json

As you may know, I'm a big fan of JSON and I am working on releasing a new version of my JSON tools real soon. Meanwhile on the SkySQL Solutions Day on April 26 I gave a talk on JSON with MySQL and MariaDB, and the slides are available on slideshare.

/Karlsson

In Santa Clara now. 2 talks coming up

+0

-0

posted by Anders Karlsson on Wed 24 Apr 2013 18:49 UTC
Tags:

(edit) mysql, json

I'm in Santa Clara for Percona Live now, and things are looking good! The announceent on the merger of Monto Program and SkySQL is a good one! If you are around, I'll be speaking on MySQL on AWS on Thursday at 1:50 PM in Ballroom F. On Friday at SkySQL Solutions day (if you are at Percona Live and don't know about this, registration is free! Come see us, the program is here: http://www.skysql.com/content/mysql-cloud-database-solutions-day-schedule) I'll be talking about MySQL and MariaDB with JSON at 11:15 AM in Grand Ballroom B!

I'm also about to release a new version of my MySQL JSON tools real soon!

/Karlsson

Searching document stores in 2013: from 1983 to SQL:2003 in a blink?

+2

-0

posted by Ulf Wendel on Thu 17 Jan 2013 16:22 UTC
Tags:

(edit) mysql, sharding, NoSQL, json, PlanetMySQL (en), N1NF, NF2, normal form

I love the new NoSQL systems: more choices! After years of RDBMS dominance there are hundrets of NoSQL systems offering a wide range of data models, data distribution strategies and interfaces. Polyglot persistence describes the market change. I am most fascinated by document stores: nested data and data distribution go hand-in-hand. Nested data, finally. And, for those who like it: schemaless or even schemafree. Maybe something to learn for MySQL? But their search capabilities… A word or two on SQL (SELECT … FROM … WHERE – SFW) and nested data.

Learn from NoSQL document stores

The classical relational data model requests all data to be in

[Read more...]

Two Cons against NoSQL. Part I.

+1

-1

posted by Roberto V. Zicari on Tue 30 Oct 2012 16:57 UTC
Tags:

(edit) mysql, postgres, Oracle, Open Source, Uncategorized, sql, ibm, analytics, hadoop, Excel, csv, big data, NoSQL, mongodb, json, riak, voltdb, basho, nosql databases, Cindy Saracco, Clustrix, document stores, Dwight Merriman, InfoSphere BigInsights, John Hugg, New and old Data stores, relational databases, Steve Vinoski

Two cons against NoSQL data stores read like this: 1. It’s very hard to move data out from one NoSQL to some other system, even other NoSQL. There is a very hard lock in when it comes to NoSQL. If you ever have to move to another database, you have basically to re-implement a lot [...]

Open World 2012

+0

-0

posted by Michael McLaughlin on Thu 04 Oct 2012 18:30 UTC
Tags:

(edit) mysql, Oracle, Java, javascript, Python, erlang, NoSQL, json, Oracle 12c

In prior years a daily update from Open World was possible, but this year my schedule was too full to support it. This is my compendium of thoughts about MySQL Connect, JavaOne, and Open World 2012.

MySQL Connect was great – good sessions re-enforcing the positive investments Oracle is making in the product. I’ll leave to others to qualify changes in what elements of technology are opened or closed along the road to a better MySQL. The announcement of Connector/Python 1.0 GA on Saturday was great news and as a community we owe a lot to Greet Vanderkelen.

NoSQL is a hot topic along with using JSON objects and it was interesting hearing of some unequal testing paradigms to position non-Oracle solutions to be

[Read more...]

MariaDB Directions

+5

-0

posted by Monty Program Group Blog on Fri 28 Sep 2012 06:37 UTC
Tags:

(edit) mysql, General, mariadb, cassandra, json, galera, MariaDB 10, Infor

Infor announced this week, that they will provide open source database alternatives to some of their products. MariaDB has been chosen, tested, and certified by Infor to be the open source database of choice (together with MySQL) for the Infor LN and ION products. Infor LN is Infor’s flagship ERP and is sometimes better known by its former name, Baan. It has 25 years of manufacturing know-how built into it and is used by more than 5,000 companies worldwide in a wide range of industries. These include automotive, industrial equipment and machinery, high tech and electronics, and aerospace and defense. This is a big stamp of approval that even the most critical systems can be run on MariaDB.

In other news, there are currently several really interesting paths coming together into some important

+2

-0

posted by Anders Karlsson on Thu 26 Jul 2012 16:18 UTC
Tags:

(edit) mysql, import, json

This is just a quick notice that there is a new version of the JSON import tool available now. The main thing in it is that it fixes an iddues with threadinig that caused a threaded load (and this is the default) to hang of there was an error or the import was interrupted. Also, there are some minor fixes and also a runtime status printing, available by sending a SIGUSR1 signal to the process, feature is available.

Download from sourceforge.

Cheers
/Karlsson

New MySQL JSON import and export tools

+1

-0

posted by Anders Karlsson on Tue 24 Jul 2012 19:10 UTC
Tags:

(edit) mysql, json

Yo!

My idea for a JSON based SQL schema tool that I wrote about some time ago has been on the backburner as I wanted to finish two other projects:

A better JSON import tool to substitute the old mysqljsonload.
Fix up mysqljsonexport to align it with mysqljsonimport.

These two projects are now done and the program are ready for download from Sourceforge, mysqljsonimport from here and mysqljsonexport from here. There is some serious changes to

[Read more...]

Tab Sweep - JSON, OSGi, GlassFish+NetBeans experience, JAXB and JodaTime, file uploads & more

+0

-1

posted by The Aquarium on Sat 07 Jan 2012 01:00 UTC
Tags:

(edit) netbeans, Weekly, jax-rs, javaee6, json, fileupload, jaxb, jaxrs, jodatime, phaser

Recent Tips and News on Java, Java EE 6, GlassFish & more :

• JSON to Java with JDK6 (Julien)
• What does the future hold for OSGi without leader Peter Kriens? (JAXenter)
• JavaCloudGuy: Glassfish (Java EE 6) is now available as option in #cumulogic (Twitter)
• JAXB and Joda-Time: Dates and Times (Blaise)
•

[Read more...]

Drizzle JSON interface merged

+2

-0

posted by Stewart Smith on Fri 13 May 2011 06:11 UTC
Tags:

(edit) sql, drizzle, http, NoSQL, json, merge, alsosql

https://code.launchpad.net/~stewart/drizzle/json-interface/+merge/59859

Currently a very early version of course, but it’s there in trunk if you want to play with it. Just have libcurl and libevent installed and you can submit queries via HTTP and JSON. Of course, the next steps are getting a true non-sql interface going and seeing how people go with it.

MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part III

+1

-0

posted by Roland Bouman on Fri 07 Jan 2011 01:30 UTC
Tags:

(edit) ajax, javascript, MySQL User Conference, json, mql-to-sql, MQL, mash-up

This is the third article in a series providing background information to my talk for the MySQL User's conference, entitled MQL-to-SQL: a JSON-based Query Language for RDBMS Access from AJAX Applications.

In the first installment, I introduced freebase, an open shared database of the world's knowledge and its JSON-based query language, the Metaweb Query Language (MQL, pronounced Mickle). In addition, I discussed

[Read more...]

MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part I

+3

-0

posted by Roland Bouman on Thu 06 Jan 2011 21:10 UTC
Tags:

(edit) ajax, javascript, MySQL User Conference, Ms SQL Server, json, mql-to-sql, MQL, mash-up

Yesterday, I wrote about how I think this year's MySQL conference will differ from prior editions. I also wrote that I will attend and that I will be speaking on MQL-to-SQL.

I promised I would explain a little bit more background about my talk, so here's the first installment.

Abstract: MQL is a JSON-based database query language that has some very interesting features as compared to SQL, especially for modern (

[Read more...]

Optimized way of getting subqueries at once using JSON

+0

-0

posted by Robert Eisele on Mon 28 Jun 2010 08:53 UTC
Tags:

(edit) mysql, PHP, optimization, json

<p>Imagine we have a user table in MySQL and similarly, a products table. Each user can now busily buy items. But this is not what this article is all about. This article is more about, that users can also favor articles they like. From a database point of view, this represents a <em>m:n</em> relation, which is resolved by an additional table. We now want to display a list of all products and all users who favor a specific article. In real world scenarios, this can be a really big amount of data, but let's bring an approximation later into play and focus on the main idea for the moment. In addition we want to know, if the person who is actually logged in into the system, already favors a certain product.</p>

Read the rest »

Liveblogging at Confoo: Blending NoSQL and SQL

+3

-0

posted by Sheeri K. Cabral on Thu 11 Mar 2010 16:11 UTC
Tags:

(edit) sql, performance, ruby, scaling, Group Blog Posts, Pythian, couchdb, column store, bigtable, hbase, Hypertable, Tokyo Cabinet, NoSQL, graph, mongodb, cassandra, json, key-value, redis, neo4j, confoo, bson, column-oriented, datamapper, document database, dynomite, gloo, graph database, gridfs, map reduce, memcacheddb, riak, voldemort

Persistence Smoothie: Blending NoSQL and SQL – see user feedback and comments at http://joind.in/talk/view/1332.

Michael Bleigh from Intridea, high-end Ruby and Ruby on Rails consultants, build apps from start to finish, making it scalable. He’s written a lot of stuff, available at http://github.com/intridea. @mbleigh on twitter

NoSQL is a new way to think about persistence. Most NoSQL systems are not ACID compliant (Atomicity, Consistency, Isolation, Durability).

Generally, most NoSQL systems have:

Denormalization
Eventual Consistency
Schema-Free
Horizontal Scale

NoSQL tries to scale (more) simply, it is starting to go

[Read more...]

RESTful PHP Web Services – reviewed

+1

-0

posted by Matt Reid on Thu 21 Jan 2010 19:53 UTC
Tags:

(edit) mysql, PHP, Open Source, web services, xml, Programming, rest, json, programing

I’ve been using a lot of RESTful services these days and have been waiting for a good book that is dedicated to the topic. I recently received a copy of ‘RESTful PHP Web Services’, which does a successful job of outlining proven concepts in current web technology. If you want to learn the methods for creating and consuming RESTful services then you will find many examples in this book. From the architectural plans to well thought out code samples, the book covers a lot of ground in a relatively quick read.

The first chapter gives the reader a quick introduction to RESTful services and the most common PHP frameworks in use at the time of writing. I particularly enjoyed the section on the Zend framework due to

[Read more...]

Drizzle query monitoring

+0

-0

posted by Diego Medina on Fri 28 Aug 2009 02:10 UTC
Tags:

(edit) mysql, perl, drizzle, plugin, gearman, MEM, json

Disclaimer:

This blog post is about things I did on my own free time, not endorsed by my employer.

A little over a month ago, Ronald posted a blog about the different query logging plug-ins that are available for Drizzle. This was pretty exciting news, especially when I saw the details that were included in the logs.

Meanwhile, a few weeks ago, I started looking at the REST API that comes with the MySQL Enterprise Monitor (http://www.mysql.com/products/enterprise/monitor.html).

The result is that we can now see most of the information returned by the plug-in, on the Dashboard.

[Read more...]

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

MySQL Links

Top 20 Most Active Authors

Oracle MySQL Blogs

Top 10 Vendor Blogs

Learn from NoSQL document stores