Features of Transactd 3.0
- New! Data access without schema table
- New! Support NULL field
- New! Support data type DATE, TIME, DATETIME, TIMESTAMP on all versions of MySQL/Mariadb
- New! Add BitField class
- New! Support field default value
- New! Support MySQL5.7 / Mariadb10.1
- Improved! Improve interoperability with SQL
- Improved! Improve reliability with adding many tests
- Simple and lightweight queries
- High-speed JOIN and distributed queries
- Easy development
Simple and lightweight queries
Transactd provides not only high-speed single record access, but also high-speed multi records access.
query.where("id". "=>", 1).and_("id", "<=", 100)
As above, the syntax is easily and understandable, similar to SQL. Of course, ORDERBY, JOIN and GROUPBY are also possible. Read details in blog (Japanese)...
High-speed JOIN and distributed queries
Transactd 2.0 JOIN tables on the client side. Therefore, it is possible to JOIN tables in the same database of course, it is also possible to JOIN tables in different servers in the same way.
Moreover, in most cases, you can get results faster than JOIN in SQL. Because of JOIN is implemented in C++, you can get the results in a similar speed in PHP, Ruby or ActiveX client.
There are "vertical scaling" which increase the processing power of each servers and "horizontal scaling" which increase the number of server. Migration to Transactd from SQL will achieve the vertical scaling easily. It means that reduce the number of servers and operating costs.
If access will increase and horizontal scaling will be needed, Transactd will demand to change application code only a little bit. You can move table to other server, and use it with distributed queries.
There are extensions for PHP, Ruby and ActiveX which wraps fast C++ implementation. Both of server plugin and client libraries work on Windows, Linux and Mac OS X.
It also can be used in web frameworks like Ruby on Rails. If you develop desktop application, you can use it from RAD like .NET or C++ builder.