Mini-interview about Firebird Conference 2014 with Mark Rotteveel
Today’s guest is Mark Rotteveel, developer of JayBird, Firebird JDBC driver, and speaker at Firebird Conference 2014.
Category: General news
Firebird related news
Q/A : Why does Firebird truncate decimal places when dividing?
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
FB TraceManager V3.5.2 has been released
 |
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.
ANN: CopyCat LiveMirror 1.3
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.
Interview with the author of Sqitch (database change management application)
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
Mini-interview with Paul Reeves
We started a series or mini-interviews with speakers of Firebird International Conference 2014. The second guest is Paul Reeves
Mini-interview with Ann W. Harrison
We are starting series or mini-interviews with speakers of Firebird International Conference 2014. The first guest is Ann W. Harrison
Database .NET 13.0 released
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.
- New features and improvements from 12.4 to 13.0 (2014/09/22)
- Updated to FirebirdSql.Data.FirebirdClient.dll 4.5.1
- Added [ADV] Advanced Browsing Options
- Added [ADV] Advanced Edit Options
- Added Column Properties
- Added Exporting and Displaying Hexadecimal string
- Added Decrease Indent and Increase Indent
- Added Restoring last object location
- Improved Code Folding
- Improved Automatic brace completion
- Improved AutoComplete and IntelliSense
- Improved Query Builder
- Improved Selected Text to Query Builder
- …and more.
You’re welcome to download it from http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multlanguage.
Avoding blind sql injections in #php
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)
Firebird Manual Pages Reorganisation and cleanup
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