Recent

Author Topic: Firebird and SqlLite  (Read 9095 times)

xinyiman

  • Hero Member
  • *****
  • Posts: 2152
    • Lazarus and Free Pascal italian community
Firebird and SqlLite
« on: June 29, 2010, 11:39:22 pm »
Hello, I would ask those who have already used or firebird SqlLite the validity of the DB. In as much sense until you can handle lots of data in an easy manner? Assuming a normal amd dual core with 4 GB of RAM can handle rapidly a mass of about 20 million records? The simultaneous multi-user supported? Thanks
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Firebird and SqlLite
« Reply #1 on: June 30, 2010, 01:33:04 am »
Hello, I would ask those who have already used or firebird SqlLite the validity of the DB. In as much sense until you can handle lots of data in an easy manner? Assuming a normal amd dual core with 4 GB of RAM can handle rapidly a mass of about 20 million records? The simultaneous multi-user supported? Thanks

I use Firebird server (multi-user) on an Intel dual core machine & even though my database does not have 12 million records (yet), it contains many stored procedures used for creating ad-hoc reports & dynamic user defined queries. It runs smoothly without problems.

For more details of Firebird use in large multiuser environments, consult the IBPhoenix website below
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1277891375:700673&page=ibp_users_firebird

I tend to use sqlite for smaller single-user projects. I've never used it in a multi-user environment.
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

xinyiman

  • Hero Member
  • *****
  • Posts: 2152
    • Lazarus and Free Pascal italian community
Re: Firebird and SqlLite
« Reply #2 on: June 30, 2010, 01:38:25 am »
Thank you
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Firebird and SqlLite
« Reply #3 on: June 30, 2010, 02:06:04 am »
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

fredycc

  • Sr. Member
  • ****
  • Posts: 264
Re: Firebird and SqlLite
« Reply #4 on: June 30, 2010, 01:40:36 pm »
Hi, xinyiman; I use Firebird server on machines with similar specifications, over windows and linux, not 20 million records yet but 9 Gb of data, why? I stored some blob data, like pictures without problems, with the new version of firebird 2.5 release 2 you can query to a external firebird database, this works great; I have many stored procedures and udf, In my case I can compile with lazarus differents versions of my udf for different platforms.

SQlite works great for single user, I use it with wince.

xinyiman

  • Hero Member
  • *****
  • Posts: 2152
    • Lazarus and Free Pascal italian community
Re: Firebird and SqlLite
« Reply #5 on: June 30, 2010, 09:17:59 pm »
Thank you infinitely! Then the blob for images work well with firebird and works well even remotely Question? Well it was just what I needed to know! Many thanks
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

xinyiman

  • Hero Member
  • *****
  • Posts: 2152
    • Lazarus and Free Pascal italian community
Re: Firebird and SqlLite
« Reply #6 on: June 30, 2010, 09:20:38 pm »
FireBird there with a GUI that is easy to create tables in a visual way, such as phpMyAdmin for MySql?
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Firebird and SqlLite
« Reply #7 on: June 30, 2010, 10:07:44 pm »
I can also confirm that Firebird works great with blob data fields.

FireBird there with a GUI that is easy to create tables in a visual way, such as phpMyAdmin for MySql?

Here are the ones I've personally used

1) IBExpert Personal Edition   http://ibexpert.net/ibe/index.php?n=Main.PersonalEdition
It is free & is the one I currently use. Available in 13 languages. It is miles better than the oft-quoted free FlameRobin & in addition, IBExpert can work in Ubuntu Linux using Wine. I simply can't do without it. All the good work & success I've had with Firebird databases is due to this excellent piece of freeware. Their IBExpert Developer Studio has much more features but I find that the Personal Edition is enough for my needs.

2) DbVisualizer   http://www.dbvis.com/
A "universal" database manager. Works on all platforms (Windows, Linux & Mac) because it was written in Java. They have a free limited personal version that needs to be activated using a freely obtained license key. Can be a little messy to set up. It requires the Jaybird dll that enables java to Firebird connections.

3) Firebird Maestro   http://www.sqlmaestro.com/products/firebird/maestro/
This is an excellent product but it is not free. It is one of the best Firebird database managers I've ever seen.

4) SQLManager Lite for Interbase & Firebird  
http://www.sqlmanager.net/en/products/ibfb/manager
A free limited version of their full scale SQLManager product. Does a good job.

By the way, if you need to manage SQlite databases, try the free SQLite Expert Personal Edition http://www.sqliteexpert.com/download.html

Happy hunting.  :D
« Last Edit: June 30, 2010, 10:13:45 pm by JD »
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

xinyiman

  • Hero Member
  • *****
  • Posts: 2152
    • Lazarus and Free Pascal italian community
Re: Firebird and SqlLite
« Reply #8 on: June 30, 2010, 10:17:12 pm »
Thank you
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

clauslack

  • Sr. Member
  • ****
  • Posts: 275
Re: Firebird and SqlLite
« Reply #9 on: July 01, 2010, 04:10:36 pm »
This is another great GUI for Firebird.
http://www.flamerobin.org/

FlameRobin is a database administration tool for Firebird DBMS.
Our goal is to build a tool that is:
   - lightweight (small footprint, fast execution)
   - cross-platform (Linux, Windows, Mac OS X, FreeBSD, Solaris)
   - dependent only on other Open Source software

and

The Firebird FAQ
http://www.firebirdfaq.org/

Regards

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Firebird and SqlLite
« Reply #10 on: July 03, 2010, 10:59:12 am »
This is another great GUI for Firebird.
http://www.flamerobin.org/

FlameRobin is a database administration tool for Firebird DBMS.
Our goal is to build a tool that is:
   - lightweight (small footprint, fast execution)
   - cross-platform (Linux, Windows, Mac OS X, FreeBSD, Solaris)
   - dependent only on other Open Source software

and

The Firebird FAQ
http://www.firebirdfaq.org/

Regards

I must confess FlameRobin has improved a lot over time but I still personally find it too limited for serious work. FlameRobin will get better & may one day offer features needed to replace other DBMS but it is not there yet.
« Last Edit: July 03, 2010, 11:00:57 am by JD »
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

cdbc

  • Sr. Member
  • ****
  • Posts: 354
    • http://www.cdbc.dk
Re: Firebird and SqlLite
« Reply #11 on: July 03, 2010, 11:08:38 am »
Hi xinyiman

Have a look at fenixsql, http://fblib.altervista.org

This tool is written in pascal...

hth - Regards Benny
If it ain't broke, don't fix it ;)

xinyiman

  • Hero Member
  • *****
  • Posts: 2152
    • Lazarus and Free Pascal italian community
Re: Firebird and SqlLite
« Reply #12 on: July 05, 2010, 08:01:09 am »
Thank you
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

 

TinyPortal © 2005-2018