Plazma ERP+CRM – can be used with Firebird
Plazma ERP+CRM is user-friendly application for small and middle business and here is the faq
Month: July 2008
Apache, PHP and Firebird Performance Tuning
In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.
The only major changes from the last post is that I’ve now upgraded the database engine to the “Firebird v2.5 Alpha 1” that supports SMP, and that the application now contains more base data in the tables.
Firebird 2.5 Alpha 1
The Firebird Team is pleased to let loose the first Alpha of Firebird 2.5, more or less feature-complete and ready to field-test. Kits are available for 32-bit and 64-bit Windows and Linux. So – please test it well and report your experiences (good or bad) to the firebird-devel list.
Do make a point of studying the release notes (available on-line and also in the download kits) as V.2.5 is to be a macro release introducing the architecture that will progress into Firebird 3 as full support for fine-grained multi-threading and SMP.
FDD – getting ready for the conference
Next saturday (19/July), we will have the 5th edition of the Firebird Developers Day conference in Brazil. This is the biggest Firebird conference (regarding number of attendees) in the world. This year, there will be around 580 attendees in the conference, and if you dream about how would be to organize such big conference, the picture below can give you an idea: 600 folders, assembled in 3h30 by four “experienced” people (yeh, we work fast) 😉 Each folder contains a mousepad, pen, magazine, sponsor papers, CD, etc.
In the next days, I plan to post some reports and videos about the conference preparatives, etc. Stay tuned to FirebirdNews 😉
FDD is organized by FireBase.
Progress on the Entity Framework Provider for Firebird
Today, after some days/weeks, I finally created some noticable (= not only internals) progress with Entity Framework provider for Firebird.
Now, the provider is able to use, map, call, … stored procedures (and functions [very experimental]). You can select stored procedures from database, map these to some operations in EF, create “function imports” etc. You can see this working on picture:
Firebird Maestro 8.7 released
|
SQL Maestro Group announce the release of Firebird Maestro 8.7, a powerful Windows GUI solution for Firebird administration and database development. |
New version features support for Firebird 2.1 Windows authentication and some interface improvements.
The company also announces the 30% discount for all their products till Jul 20.
Vote in our new poll!
What is the language most used in your Firebird apps?
Two years ago we asked the same question. Now it is time to repeat it and see if (and how) the scenary changed. You just need to go to the mainpage of FirebirdNews and vote. Your answer will help us to find what are the major languages being used to code applications that uses Firebird as the DB engine.
DB Master beta1 released
DBMaster is a tool for working with multiple database servers and multiple databases. Sometimes it is much easier to work using a set of commands than working with wizards. DBMaster has a command language which can be used for copying Tables, Views, etc from one database to another.
Firebird 1.5 Language Reference Update available
Firebird 1.5 Language Reference Update available
————————————————
For those who don’t regularly visit the Firebird project home page, the Firebird Documentation Subproject is pleased to announce the availability of the Firebird 1.5 Language Reference Update. This reference documents all the changes in and additions to the Firebird SQL language since the fork from InterBase 6.
Translations are under way, as are versions for Firebird 2.0 and 2.1.
A full Firebird Language Reference, obviating the need for the InterBase reference, is in preparation.
Locations:
HTML: http://www.firebirdsql.org/refdocs/langrefupd15.html
PDF: http://www.firebirdsql.org/pdfrefdocs/Firebird-1.5-LangRef-Update.pdf
The Firebird Documentation Index is at:
http://www.firebirdsql.org/index.php?op=doc
Paul Vinkenoog
Firebird Documentation Team
Apache Serves Images Slowly – Testing with Firebird
The application was a test-bed app that uses the FireBird SQL database to handle sessions and dynamic data, all on the same machine. [Performance Tip :Seems that you need to put KeepAlive Off on apache to server many images and too many clients :If you have more clients than available apache children, KeepAlive settings will hurt overall performance and should be turned off.]