Feeds:
Posts
Comments

Archive for the ‘Database’ Category

TomatoCMS released with new cool back-end interface and some new features, especial is SEO module. In 2.0.7.1 version, we improved some more features, best is link provider, it’s very useful feature. Below is some features available in TomatoCMS 2.0.7.1:

Improvements: Install Wizard (core module)

In 2.0.7 and earlier versions, there is no way to select the language at Install Wizard as well as switch to other language in back-end.
In this 2.0.7.1 version, at the first step of Install Wizard, you can choose the language from one of built-in languages or upload a new one.
After uploading the package, you can choose uploaded language.

Image

(more…)

Read Full Post »

MySQL OOP Database Script

This MySQL OOP Database connection class was submitted by David Rosthorn and it makes MySQL queries more manageable by breaking down the key functions and features of the MySQL module found in all standard PHP installations and creates an environment that is a little faster to work with.

 

Notes from David Rosthorn regarding the Monday, June 30, 2008 Update to version 1.05:

rather than just setting a blank string as “nothing” in the DB, it literally sets it as NULL like it should. The only catch is that you HAVE to make sure you set up the tables to allow nulls in the appropriate fields where nulls might occur so you can do a proper SQL query:

(more…)

Read Full Post »

The WebKit team has implemented an implementation of the HTML 5 client side storage API which gives you an asynchronous API:

JAVASCRIPT:

  1.  
  2. var database = openDatabase(“Database Name”, “Database Version”);
  3.  
  4. database.executeSql(“SELECT * FROM test”, function(result1) {
  5.    // do something with the results
  6.    database.executeSql(“DROP TABLE test”, function(result2) {
  7.      // do some more stuff
  8.      alert(“My second database query finished executing!”);
  9.    });
  10. });
  11.  

Once you have the latest nightly, you can check out their database example and even see the tool that is available in the Web inspector

Read Full Post »

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 had us all thinking about JSON being the next “turtles all the way down”.

(more…)

Read Full Post »

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:

  1.  
  2. by_lang: function(doc) {
  3.   var html = new XML(doc.content);
  4.   map(html.@lang, {title: html.head.title.text(), …});
  5. }

 

(more…)

Read Full Post »

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 about it is that it’s library agnostic and can work with all of the popular frameworks.

The idea came to me as I was working on Joe’s Goals 2.0 and I realized that one of the hardest parts about building any Web 2.0 application is working with data. There is no good way to use JavaScript by itself to gather, search, and maintain a collection of data. There are lots of great ways to great interfaces now days, but what about the data behind them? Taffy DB is the result of the research and testing I did for Joe’s Goals and is now avaliable for everyone to use.

(more…)

Read Full Post »

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 tables as models.
* full CRUD support.
* events on(Before/After)Delete/Save/Update.
* SQL LIMIT/OFFSET support.
* order by support.
* automatic creation of tables.
* selecting and deleting over relations.
* easy iterating with each syntax like in Ruby,support for query chaining and more.
* basic introspection support.
* transaction support.
* self relations.
* support multiple backends and multiple dialects,currently MySQL (in Jaxer only) and Sqlite (Jaxer, Gears and AIR).

(more…)

Read Full Post »

Older Posts »