General news Archives - Page 99 of 207

Mini-interviews with speakers Firebird Conference 2014 speakers roundup

October 7, 2014 mariuz Leave a comment

Alexey Kovyazin wrote on linkedin Firebird group :

We started series of mini-interviews with Firebird Conference 2014 speakers:
Ann Harrison: http://www.firebirdsql.org/en/news/mini-interview-with-ann-w-harrison-53224/
Paul Reeves: http://www.firebirdsql.org/en/news/mini-interview-with-paul-reeves-53229/
Mark Rotteveel: http://www.firebirdsql.org/en/news/mini-interview-about-firebird-conference-2014-with-mark-rotteveel-53233/

Stay tuned for more interviews!
Don’t miss the last chance to register at Firebird event of the year: Prague, October 24-25: http://www.firebirdsql.org/en/firebird-conference-2014/

Mini-interview about Firebird Conference 2014 with Mark Rotteveel

October 3, 2014 mariuz Leave a comment

Today’s guest is Mark Rotteveel, developer of JayBird, Firebird JDBC driver, and speaker at Firebird Conference 2014.

Q/A : Why does Firebird truncate decimal places when dividing?

October 3, 2014 mariuz Leave a comment

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

October 1, 2014 tsteinmaurer Leave a comment

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

October 1, 2014 jonneve Leave a comment

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)

September 29, 2014 mariuz Leave a comment

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

September 29, 2014 mariuz Leave a comment

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

September 26, 2014 mariuz Leave a comment

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

September 21, 2014 fishcodelib Leave a comment

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

September 20, 2014 mariuz Leave a comment

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)

« 1 … 97 98 99 100 101 … 207 »