Firebird related news
Firebird truncates decimal places when dividing, rather than rounding. Furthermore, it bases the number of decimal points in the returned value on the number of decimal places in the numerator and denominator.
Why is Firebird truncating instead of rounding? And why does it base the returned value on the number of decimal places in the query?
Here is the answer to the Question on StackOverflow
 |
Upscene Productions is excited to officially release FB TraceManager V3.5.2! |
This release adds UI docking capabilities, improved Firebird 3 support and fixes minor bugs.
More information is available here:
http://www.upscene.com/news/item/20140930
Feel free to check out the following V3.5 demo video
More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.:
http://www.upscene.com/fb_tracemanager/
Thanks for your continued support.
I am pleased to announce that CopyCat LiveMirror 1.3 is officially available!
CopyCat LiveMirror is our database mirroring and backup tool, designed to make it trivial to setup a one-way replication between two Firebird databases, so that you can easily have a reliable, up-to-date backup at your fingertips, at all times. Please refer to our product page for more information
Changes in this release :
* Various core changes and minor bug fixes.
* Fixed bug saving database configuration data.
* Fixed bug causing errors with wide string fields in some situations.
* Improved log viewer window so that it’s responsive even when holding a large log file.
* Added an error reporting module allowing for more detailed error messages and bug reports.
* Fixed bug causing automatic replication to stop after database connection loss. In such a case, LiveMirror will now continue trying to reestablish a connection every time replication fires.
* LiveMirror now excludes fields with errorneous field names (DATE, TYPE, USER, etc) that were allowed in older versions of Firebird and can still be present in some databases.
* Automatically grant full rights to all users for RPL$ system tables created by LiveMirror, so that there will be no error when inserting into RPL$LOG through the triggers when a user makes changes to the database.
As you might now Ștefan Suciu created a Firebird port for Sqitch
Bellow is a interview with the author of Sqitch : David Wheeler with a few Firebird mentions
ps: There is a GUI for Sqitch – Simple SQL change management created by Stefan
https://github.com/stefansbv/sqitch-gui
We started a series or mini-interviews with speakers of Firebird International Conference 2014. The second guest is Paul Reeves
We are starting series or mini-interviews with speakers of Firebird International Conference 2014. The first guest is Ann W. Harrison
Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.
You’re welcome to download it from http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multlanguage.
Common steps in avoiding sql injections
1.First step is to sanitize the inputs and never trust what comes from POST/GET :
2.Another tip is to Always use prepared statements (in ibase) or PDO that is more safe (query stays unchaged while executing the php script) and the parameters will be the only changes in the queries (feed them from post/get) also casting the variables to int and string is a good way filtering is not enough, casting is better
3.Another posibility is using stored procedures were business rules are done inside firebird and you specify only the parameters (this way the query stays unmodified and the where clause can’t be changed by evil hackers)
Paul Vinkenoog cleaned up that page and wrote on Firebird-docs:
– On top are the most important version-specific docs for the currently supported versions, i.e. 2.5 and 2.1 Quick Start Guides and LangRef Updates.
– After that, the Command Line Utilities manuals, followed by other user manuals, reference material and the Firebird licenses.
– Then come the manuals on no longer supported versions, the IB6 manuals, and finally the manuals for Firebird docwriters.
I’m sure we can still do better, by integrating some of the docs pages and using only one line per document (with the available language links listed like we used to, e.g. “en fr de nl”), which saves a lot of vertical scrolling, but that’s for another day.
Cheers
ps: Thanks Lukas Eder for suggestions
I think it is time for updating the WordPress’s theme used in FirebirdNews. The actual theme is based in the Firefox theme (old and no more maintained) and doesn’t support well some of the new features available in the most recent versions of WordPress.
WordPress has thousands of themes, and choosing the right one is a difficult task, when so many choices are available. So, if you know a good and beautiful theme that could be used in this site, please comment below.
Remember that we are a news site, so theme should fit this purpose. Also, it should has no cost (meaning it should be free or donated)
