#ilovefs , #ilovefirebird:I Love Free Software Campaign , I love Firebird

Today is the day when you can share your love towards Firebird and the Free Software world (libreoffice , qt , debian)
There are lots of ways to declare one’s love… Here are some ideas on how you can go public and proclaim your love to Free Software/Firebird

  • Send active Free Software supporters a message thanking them for their work
  • Microblog about how you love Free Software, and tag those messages with #ilovefs/#ilovefirebird.
  • Hug a developer (ask permission first!)
  • Buy your favourite developer a drink. Or buy someone else a drink and while savouring it, tell him/her about your favorite Free Software application!

ps whey you search for i love firebird i have this example of trim function 🙂

select trim (‘la’ from ‘lalala I love Firebird’) from rdb$database
— returns ‘ I love Firebird’

Firebird used on a site with 1 Million users / day

Q:What kind of system is this? .The response is on Firebird-support

Monitoring software with also web access by many many users ~1 000 000
They do something which need transaction and some select(reports) which “not need” transaction
but in transactional database select also start short transaction then i can not remove it creation..
1 000 0000 x 10 queries per day i got 10 000 000 transaction+ system self generate 8 000 000 transaction per day (to
storing/updating/computing.. data)
and Forced Writes are ON but database work on some not mechanical device like normal HDD and corruption is reduced to minimal possible but this transaction counter do may problem :/

Karol Bieniaszewski

Tip: Using isql-fb / isql with readline in Debian/Ubuntu instead of libedit

Seems that readline does have utf-8 support and can be used for inserting/selecting accented chars
Check if libedit is used instead of readline

ldd /usr/bin/isql-fb | grep libedit
libedit.so.2 => /usr/lib/libedit.so.2 (0x00007f3dcbd7b000)

export LD_PRELOAD=/lib/libreadline.so.6

check if is preloaded

ldd /usr/bin/isql-fb | grep readline
/lib/libreadline.so.6 (0x00007fc661d22000)

Then use isql-fb as usual

SQL> select * from employee where first_name = ‘Å‘’

1 138 139 140 141 142 296