Database


Database technology including JSINQ, google.wspl.Database, JavaScriptDB, JSON and others.


Tuesday, March 30th, 2010

JSINQ 1.0: now fully supports .NET 3.0 query operators

Category: Database, JavaScript

Kai Jäger’s JSINQ has now gotten to the long sort after 1.0 release. Kai has kindly shared a few thoughts on the release and the project: I’m happy to announce that one year after its initial release, JSINQ is now stable and packed with new features. Just like the previous version, JSINQ supports the complete Read the rest…

Posted by Dion Almaer at 6:25 am
6 Comments

+++--
3.1 rating from 27 votes

Tuesday, November 24th, 2009

Moving from the Couch to the LawnChair

Category: Database, JavaScript

We have mentioned attempts at doing Couch in the browser before, and now we have a new project. Brian LeRoux of PhoneGap/Nitobi fame, has taken a lighter couch outside as he announces Lawnchair that aims at being applicable for mobile Web usage (but can of course work anywhere else): Features micro tiny storage without the Read the rest…

Posted by Dion Almaer at 6:20 am
8 Comments

+++--
3.2 rating from 13 votes

Friday, May 29th, 2009

Web Storage Portability Layer: Abstract on top of HTML5 and Gears Storage

Category: Database, Google

Robert Kroeger has released a nice library for local database access. The Web Storage Portability Layer nicely abstracts on top of HTML5 and Gears for database access. The WSPL consists of a collection of classes that provide asynchronous transactional access to both Gears and HTML5 databases and can be found on Project Hosting on Google Read the rest…

Posted by Dion Almaer at 8:45 am
6 Comments

++++-
4 rating from 32 votes

Tuesday, April 21st, 2009

Persevere’s JavaScriptDB: Impressive JSON Performance

Category: Database, JavaScript, JSON

Kris Zyp recently posted about an intriguing new chapter in the application persistence space: The latest beta of Persevere features a new native object storage engine called JavaScriptDB that provides high-end scalability and performance. Persevere now outperforms the common PHP and MySQL combination for accessing data via HTTP by about 40% and outperforms CouchDB by Read the rest…

Posted by Ben Galbraith at 1:00 pm
4 Comments

++++-
4.6 rating from 51 votes

Browsing on the Couch

Category: Database, JavaScript, JSON, Library

Atul Varma, a fantastic colleague in Building “S” at Mozilla, has been playing with a JavaScript implementation of CouchDB called BrowserCouch: BrowserCouch is an attempt at an in-browser MapReduce implementation. It’s written entirely in JavaScript and intended to work on all browsers, gracefully upgrading when support for better efficiency or feature set is detected. Not Read the rest…

Posted by Dion Almaer at 6:34 am
1 Comment

+++--
3.8 rating from 22 votes

Tuesday, February 3rd, 2009

HTML5 Features in latest iPhone; Application Cache and Database

Category: Database, HTML, iPhone, Mobile, Standards

Brad Neuberg told me about two cool additions to the iPhone that now use HTML5 features: Safari JavaScript Database Programming The HTML 5 specification provides a new mechanism for client-side data storage: JavaScript database support. HTML 5 is currently in development by the Web Hypertext Application Technology Working Group (WHATWG). JavaScript database support is available Read the rest…

Posted by Dion Almaer at 12:31 am
7 Comments

+++--
3.9 rating from 25 votes

Wednesday, October 1st, 2008

JStORM: A New JavaScript Object-Relational Mapper

Category: Database, JavaScript

Uriel Katz wrote in to tell us that he’s burned his GearsORM framework to the ground to create the entirely new JStORM framework, announced in his blog. JStORM currently supports Google Gears, Aptana Jaxer, and Adobe AIR, but it’s still bleeding edge: no documentation yet, just code. But the feature-set is interesting: * define your Read the rest…

Posted by Ben Galbraith at 7:29 am
7 Comments

+++--
3.4 rating from 27 votes

Tuesday, March 11th, 2008

Taffy DB Javascript Database

Category: Ajax, Database

Working client-side with data can be challenging and projects have tried to address this in different fashions. Ian Smith, creator of Joe’s Goals, has his own approach. He’s created Taffy DB, a lightweight Javascript database that allows you to insert, update, delete, order, loop, and query against a client-side collection of data. The great thing Read the rest…

Posted by Rey Bango at 12:37 pm
11 Comments

+++--
3.9 rating from 64 votes

Wednesday, March 5th, 2008

CouchDB: Using E4X to get the XML back

Category: Database

Christopher Lenz has been spending time on the CouchDB project. He got lulled over when CouchDB went to JSON. He talks about how “CouchDB is pretty well positioned for storing and querying XML data in addition to JSON” via the E4X support that it gets out of the box as it uses SpiderMonkey. javascript < Read the rest…

Posted by Dion Almaer at 6:18 am
1 Comment

+++--
3.6 rating from 16 votes

Thursday, January 3rd, 2008

Apache CouchDB: Congrats to IBM and Damian Katz

Category: Database

CouchDB has been getting people re-energized about DB stuff recently. Some got gung-ho about the OODBMS and that fizzled and people went back to the “ug, I guess we just do the SQL thing and be done with it… and maybe use an ORM if we really hate it”. Then the Couch came along and Read the rest…

Posted by Dion Almaer at 7:27 am
5 Comments

++++-
4.3 rating from 30 votes

Monday, October 22nd, 2007

WebKit Does HTML5 Client-side Database Storage

Category: Browsers, Database

The WebKit team has implemented an implementation of the HTML 5 client side storage API which gives you an asynchronous API: javascript < view plain text > var database = openDatabase("Database Name", "Database Version");   database.executeSql("SELECT * FROM test", function(result1) {    // do something with the results    database.executeSql("DROP TABLE test", function(result2) {   Read the rest…

Posted by Dion Almaer at 8:03 am
16 Comments

++++-
4.5 rating from 30 votes

Friday, August 24th, 2007

Adobe AIR: Can we have synchronous queries, please?

Category: Adobe, Database

Justin Palmer has an interesting post about the dealing with the asynchronous nature of Adobe AIR’s SQLConnection class and the challenges it poses when dealing with the DBMS’ response. Justin shows some creative ways of working around this through the use of Responder objects and event listeners: var connection = new air.SQLConnection(); connection.open(air.File.applicationResourceDirectory.resolve(‘development.sqlite’)); var statement Read the rest…

Posted by Rey Bango at 6:00 am
9 Comments

++++-
4.1 rating from 19 votes

Wednesday, February 7th, 2007

OpenToro 4.0: Ajax Web Database Publisher

Category: Database, Framework, Java

OpenToro 4.0, an open source Ajax Web Database Publishing tool, has been released. OpenToro is a CMS written in Java that allows the development of database driven web Applications in a quick and agile way. If you need to build simple CRUD applications that are faces onto your database, this could be a tool for Read the rest…

Posted by Dion Almaer at 5:29 am
5 Comments

++++-
4.1 rating from 43 votes

Friday, July 7th, 2006

PHP-Based MySQL-to-JSON Converter

Category: Database, Remoting

A new PHP component by Adnan Siddiqi accepts a MySQL result set and converts it into a JSON message. MySQL To JSON: This class can be used to convert data from MySQL query results into a JavaScript expression in JavaScript Object Notation. It takes a MySQL query result handle and retrieves the query result column Read the rest…

Posted by Michael Mahemoff at 7:23 am
10 Comments

+++--
3.5 rating from 95 votes

Thursday, March 2nd, 2006

Under the Radar: Session 2 – Make It Easy 2.0

Category: Database, Editorial, Office

After four “When” companies got a chance to impress us with their Web 2.0 goodness, four “Make It Easy” concerns are now up to the plate: Dabble DB, Rallypoint, The Form Assembly, and Zoho. Each company has eight minutes to present their wares. A panel (Michael Arrington, Rael Dornfest, and Krishna Akella in this session) Read the rest…

Posted by Ben Galbraith at 1:57 pm
8 Comments

+++--
3.6 rating from 47 votes

Wednesday, January 25th, 2006

AjaxMyTop: MySQL Monitor

Category: Database, Showcase

We’ve seen in-browser SQL, a database administrator, and even a database designer. Now there’s a database monitor… AjaxMyTop shows active MySQL connections. You get a data grid showing connections, each showing ID, user, duration, and so on. Periodic Refresh ensures the connections are kept fresh, and you can easily set the refresh period in an Read the rest…

Posted by Michael Mahemoff at 11:06 am
9 Comments

++++-
4.1 rating from 56 votes