Author: mariuz
http://wiki.ubuntu.com/Mariuz
Free Pascal full text index/searcher classes committed in Lazarus svn
ХудожникMichael Van Canneyt announced his full text indexer project:
I’ve committed a file/database indexing and search engine, fpindexer, to SVN.
It was developed by Darius Blaszijk, with help from me. One of the planned uses is
to create searchable documentation. I’ve also (in a private project) used it to
implement full-text search on a database that doesn’t support that natively.
Django south fork with support for firebird was merged into main trunk (original project)
News via Maximiliano Robaina and here is the patch
To check more about the project you can check it’s homepage
Time Track is a program written in Lazarus and tiopf to allow people to track projects (with Firebird backend)
See the lazarus full thread and you can clone the git repository
It’s a small app that sits in the tray, and can be used to manage project time.
If there is interest, I can donate it to the Lazarus community. It also serves
as a nice example of how to program Lazarus and tiOPF.
It also keeps a todo list and a list of interruptions.
(the helpdesk walks in and out of my office, which I started tracking to
prove that this practice costs me 1.5 hours a day.)
I posted the project at
http://www.freepascal.org/~michael/timetrack.zip
You’ll need tiOPF and a database server.
I use (and recommend) Firebird, but changing it to something
else takes about 2 lines of code.
The included time.sql file creates the database.
The Firebird Book: a Reference for Database Developers – Edition II (Beta) is now available
The Firebird Book: a Reference for Database Developers – Edition II (Beta) is now availble directly from IBPhoenix in electronic format on the March 2012 Edition of the Developer DVD. It covers Firebird up to Firebird V2.5 .
If you buy a copy of the early version, you will have automatic accessto updated versions as they are released.If you have a subscription to the IBPhoenix Developer DVD you will automatically recieve your copy via post shortly.
www.ibphoenix.com
www.ibphoenix.com
Philippe Makowski finished the port of FDB (Firebird Driver) to Python 3
Philippe Makowski wrote on google plus
I finished the port of FDB to Python 3 all tests seems ok
next step : merge into FDB upstream
You can grab it there :https://github.com/pmakowski/fdb/tags (tag is v0.1)
git repo : https://github.com/pmakowski/fdb
Timeout records – Feature request
For several years now, I’m yearning for a feature that I think that all SQL based databases that I know are missing, and throw it back to the program side.
The feature I wish to have is a way to set a specific record to be valid for only a known period of time, and when the time is up, I’ll be able to do something.
In this post I’ll try to create some sort of general specification for such feature, and I hope that there will be many comments on this that will benefit everyone, and I hopeful, that they will make the idea better.
FDB python driver implements services (Python 3 only for the moment)
Philippe Makowski announced that he just committed new files in github fdb repository
He implemented firebird services api for Python 3 driver, this driver version doesn’t work yet for Python 2, and it is only the first step.
Certainly some improvements would be welcome.You can see diff here
The hope is that he will start working on fbcore soon
Firebird: choosing an owner for database deployment
Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.
It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer’s computer.
Read the rest on Accounting++ blog
New IBExpert Version 2012.02.21 available
News from ibexpert page
New Data import, Extract metadata and Search metadata features, new IBEBlock functions, and more
New features include:
- Data import: now you can convert Boolean values to
smallintvalues when importing data into a new table. You can also now automatically generate simple column names for the target table. - To-Do list: now you can duplicate To-Do items.
- Extract metadata: New Always include COLLATE option.
- Search metadata: New Do not search in comments option.
- New IBEBlock functions and features.
- Many small bug fixes and minor improvements.
Since version 2011.12.01 IBExpert now uses the Firebird database and Firebird Embedded 2.5 to store all IBExpert data (registered databases, query histories etc.) by default. In previous versions by default IBExpert stored this data in the IBExpert.stg file and the user was able to change this manually in Options / Environment Options / User Database. Working with IBExpert.stg is still possible (for example, if you disable the User Database manually), but you will get a warning every time you start IBExpert, and we will not support this method in the future.
- The Customer version (
setup_customer.exe) can be downloaded here (for customers with valid license keys). You can also download the customer version in theIBExpert KG Download Center. If you can not see it there, you might have used a different e-mail in the customer registration process or your account has already expired. - The Trial version (
setup_trial.exe) can be downloaded here (45 day test version) or from the IBExpert KG Download Center. - The free Personal version (
setup_personal.exe) can be downloaded here (version with limited features free of charge).