Page 2 of 2 First 12
  • Jump to page:
    #16
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    14
    >>1. Poor Optimizer

    Disagree on this one. The optimizer isn't the best around, but Firebird 1.5 has improved it a LOT.


    With regards,

    Martijn Tonies
    Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
    Upscene Productions
    http://www.upscene.com
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  2. #17
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  4. #18
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    14
    If it works, yes.
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  6. #19
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2004
    Posts
    4
    Rep Power
    0

    documentation?


    I hadn't heard of Firebird before this week and I've just begun looking at it.

    You list as one of Firebird's strong points:

    >[*] Very good documentations (inside of Firebird Documentation Project)

    I couldn't find much of any documentation on the firebirdsql or sourceforge websites ... Okay, the quick start guide was indeed very helpful: I got everything installed and running no problem, had my first "select * from helloworld" program up and running within a couple of hours of completing the download. But from there, well, it seemed not only pretty sparse but also contradictory. Just for example: The documentation on the JDBC driver specifically said that it did not support scrollable result sets. Okay, I'm disappointed. But then I looked at the Javadoc's on the API and they said it did support scrollable result sets, and in fact when I tried it, it worked. I found a link to an InterBase 6 SQL reference, but is that identical to Firebird 1.5 SQL? And besides, it's just a reference. I don't expect a tutorial on SQL but it would be nice to get some explanation of exactly what a "PLAN" is, for instance. And so on. I just ordered a book on Firebird from Amazon that I'm hoping will Explain It All, but if there's some good documentation on the Web I'd love to hear about it.

    Oh, one big advantage of Firebird, and the reason I'm looking at it: It comes at my second favorite place: free. (My favorite price is: they pay you to take it.) I was thinking of mySQL but they actually want, like, money for commercial licenses.
  8. #20
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    11
    Rep Power
    0

    Interbase


    + compatible -> Interbase Tools
  10. #21
  11. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2004
    Location
    Romania
    Posts
    173
    Rep Power
    11

    Thumbs up


    ++ Transactions in a multiple user enviroment
  12. #22
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    11
    Rep Power
    0

    transaction


    +++ transactions in DDL
  14. #23
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Posts
    6
    Rep Power
    0
    I also really like the embedded version.
    - allows synchronization for offline desktop users
    - really small footprint (a few MB)
    - available in .NET

    I haven't found any other open source product capable of this.

    -Dan
    http://www.dotnetfirebird.org
  16. #24
  17. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Posts
    6
    Rep Power
    0
    Originally Posted by pabloj
    From my perspective Firebird has one disadvantage:

    No Full Text Indexing

    It would be nice to have it added.
    In .NET, you can use DotLucene for fulltext search in Firebird.

    -Dan
    http://www.dotnetfirebird.org
  18. #25
  19. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Location
    Czech Republic
    Posts
    4
    Rep Power
    0
    Originally Posted by zapa
    heh for now i have been strugling with creating a test db in firebird , as the instructions in the starter pdf are for windblows and all freeBSD examples i've found so far have failed me

    anywais , i don't want to get offtopic too much ... thanks for the tip
    i have installed firebird on freebsd and i can create database without any problem. write your problem.
  20. #26
  21. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2004
    Posts
    20
    Rep Power
    0
    Originally Posted by pabloj
    From my perspective Firebird has one disadvantage:

    No Full Text Indexing

    It would be nice to have it added.
    There are some possibilities listed:

    http://groups.yahoo.com/group/firebi.../message/54782
  22. #27
  23. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Dear hugo2, reading through the link you suggested this is from Ivan's answer:
    AFAIK currently there is not any add-on ...
    and this is the answer for me, the suggested workarounds are no more than that.
  24. #28
  25. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2004
    Posts
    20
    Rep Power
    0
    Right, you wanted to say - there is no built-in fulltext indexing.
    OTOH, there are so many different fulltext system architectures, and so many different requirements for functionality / speed of indexing / speed of searching / reliability / memory requirements, that built-in fulltext would not satisfy everybody anyway. (But yes, built-in solution would be nice).
Page 2 of 2 First 12
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo