Database

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…

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…

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…

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…

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…

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…

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…

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…

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. < View Read the rest…

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…

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…

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…

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…

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…

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…