TomatoCMS released 2.0.7.1 version on 04th August, 2010

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.

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:

Read Full Post »

WebKit Does HTML5 Client-side Database Storage

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

PLAIN TEXT

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 »

Apache CouchDB: Congrats to IBM and Damian Katz

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”.

Read Full Post »

CouchDB: Using E4X to get the XML back

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.

PLAIN TEXT

JAVASCRIPT:

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

 

Read Full Post »

Taffy DB Javascript 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 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.

Read Full Post »

JStORM: A New JavaScript Object-Relational Mapper

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).

Read Full Post »

HTML5 Features in latest iPhone; Application Cache and Database

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 in Safari 3.1 and later, and in iPhone OS 2.0 and later.

You should read this documentation if you are a web developer who wants to store data locally on a user’s computer in amounts beyond what can reasonably be stored in an HTTP cookie.

Read Full Post »

Persevere’s JavaScriptDB: Impressive JSON Performance

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 249%. The new storage engine is designed and optimized specifically for persisting JavaScript and JSON data with dynamic object structures. It is also built for extreme scalability, with support for up to 9,000 petabytes of JSON/JS data in addition to any binary data.

 

Read Full Post »

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

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 Code.

There are five basic classes:

google.wspl.Statement – A parametrizable SQL statement class

google.wspl.Transaction – Used to execute one or more Statements with ACID properties

google.wspl.ResultSet – Arrays of JavaScript hash objects, where the hash key is the table column name

google.wspl.Database – A connection to the backing database, also provides transaction support

google.wspl.DatabaseFactory – Creates the appropriate HTML5 or Gears database implementation

Read Full Post »