We are starting series or mini-interviews with speakers of Firebird International Conference 2014. The first guest is Ann W. Harrison

Be Sociable, Share!

Dmitry Yemanov recently announced (in fb-devel discussion list) that Beta 1 of Firebird 3 is expected to be released in the next week.

Please take some time when Beta1 is out and do as much tests as you can, and report the problems back in fb-devel or Firebird tracker, helping the core developers to address the issues and so speeding up the schedule of the next releases .

Update from Dmitry:

Correction: Beta *code* is expected to be ready (i.e. tagged) the next
week. The release itself will appear slightly later, after composing the
docs and passing QA.

Be Sociable, Share!

NHibernate 4.0.1 General Availability is now available for download from Sourceforge and Nuget.

http://sourceforge.net/projects/nhibernate/?source=directory

This includes fixes for regressions in NH 4.0.0, and some fixes for mapping-by-code and Firebird issues.
Please see the full release notes for more information:
https://github.com/nhibernate/nhibernate-core/blob/4.0.1.GA/releasenotes.txt

Be Sociable, Share!

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.

Be Sociable, Share!

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)

Be Sociable, Share!

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

Be Sociable, Share!

Firebird International Conference 2014 will take place on October 24-25, in Prague. 2 days of the intensive talks from Firebird core and drivers developers, vendors of leading Firebird tools and even legends of the database world: Ann Harrison and Jim Starkey.

Take a look at detailed talks descriptions. Don’t miss the biggest event of the year, register now!

Be Sociable, Share!

Here is the guide on installing Firebird 2.5.3 from FreeBSD 10 Ports and
creating your first test database; also we show you how to install
Flamerobin GUI (administration tool) and the PHP driver for it. This was tested on fresh FreeBSD 10 on a kvm-linux virtual machine.

Download a compressed snapshot of the Ports Collection into /var/db/portsnap.

# portsnap fetch

Or update it.
If you are running Portsnap for the first time, extract the snapshot into /usr/ports:

# portsnap extract

If you already have a populated /usr/ports directory and you are just updating, run the following command instead:

# portsnap update

Enter firebird server ports directory:

# cd /usr/ports/databases/firebird25-server

Compile and install firebird server:

# make -DPACKAGE_BUILDING

# make install

Enable it by adding

firebird_enable="YES"

in

/etc/rc.conf
.

Start it with:

# /usr/local/etc/rc.d/firebird start

logs and security2.fdb seems to be in /var/db/firebird.

# /usr/local/bin/isql-fb

To create a new database:

SQL> create database “tmp/first_database.fdb”;

SQL> connect “/tmp/first_database.fdb” ;

Commit current transaction (y/n)? <– y

Committing.

Database: “/tmp/first_database.fdb”

SQL>

If you want to create a simple table then insert 1-2 rows and select from it; here is one example:

SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20));

SQL> show tables;

TEST

SQL> INSERT INTO TEST VALUES (1, ‘John’);

SQL> INSERT INTO TEST VALUES (2, ‘Joe’);

SQL> select * from test;

ID NAME

============ ====================

1 John

2 Joe

To quit the isql-fb console, type quit:

SQL> quit

CON>;

For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository; it can be installed by a simple:

# cd /usr/ports/databases/flamerobin/ && make install clean

Or if you don’t want to wait use pkg-add

# pkg-add -r flamerobin

To use firebird with php, you will need the php5 driver:

# cd /usr/ports/databases/php5-interbase/ && make install clean

You can choose to compile php with apache support (I have chosen cli, cgi , and apache support);

check it if is enabled with:

# /usr/local/bin/php -m

Or if you don’t want to wait compile all the php use pkg-add

# pkg-add -r php5-interbase

Be Sociable, Share!

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)

Be Sociable, Share!

More info here.

You can get the bits from NuGet FirebirdSql.Data.FirebirdClient and EntityFramework.Firebird.

Be Sociable, Share!

« Previous PageNext Page »

Link to us!

This Firebird & Interbase WebRing site owned by Carlos H. Cantu .
[ Previous 5 Sites | Previous | Next | Next 5 Sites | Random Site | List Sites ]