Howto stream/transfer Objects in Delphi over the slow internet with an Firebird Db Backend
DBRE – is a system for asynchronous point-in-time databases replication. In addition, it can be used for a single transfusion of data between the DBMS
DBRE now supports Firebird and Mysql RDBMS. In future it will be supported Oracle, ODBC, PostgreSQL and SQLite. But any other database can be included to supporting with gomomorphic interface in C++ class.
I’ve written this quite some time ago (and it didn’t receive much love since then, but it’s functional and should be bug-free), but I just noticed I haven’t mentioned it on my blog: fbsql is a clean C-API that can be used to create bindings for other languages (such as Python or Ruby). It’s much simpler to use than the raw Interbase/Firebird API and it uses IBPP internally. So it’s basically just forwarding the function calls to IBPP and abstracting the IBPP classes to a C interface that is straight forward and intuitive.
Here is the article translated from Spanish
You can see two new blog posts about Entity Framework : OnValidate-Like Validation
Yesterday, while doing Entity Framework training, I got a good question. LINQ to SQL has a nice event called OnValidate, where you can validate your data. But Entity Framework classes don’t. As the only one good point to do the validation of entities in Entity Framework is during in SaveChanges in SavingChanges event, we have to utilize this event and build validation there.
You may wonder how to use usefull coalesce operator in Firebird Entity Framework.
Today i have discovered this little gem on github , It’s an
Firebirdnews.org is a great site! Added it to my RSS feeds, but I
wonder why I haven’t heard of it before. You need to do more
advertising! 🙂 Do you happen to know how many readers you are
ED:Maybe we should promote better the website , seems that now from alexa.com
stats we have a lot of hits from Italy, so we have to tune up to reach more markets 🙂
I’m glad that you included my translation of the Firebird Security
documentation, too, but I was a bit surprised to find it there without
being notified of it.
Regarding the TsSqlDatabase stuff: It’s something I’m doing for the
company I’m working at (Germany based Treesoft, see www.treesoft.de)
and it’s currently being extended by another employee. Which problems
I wanted to solve and the basic technique that I’m using to solve it
are described here:
The project is currently in a semi-working state. My co-worker is
working with Qt to create a searchable list-view that can handle HUGE
amounts of data with astounding user experience and without the quirks
that most SQL list implementations have.
I’m going to write up a new article on this topic with more details
maybe this weekend or next week, so stay tuned. I’ll contact you when
it is finished so you can put it up on firebirdnews.org.
This blog-post may also be an interesting read to you:
but with qt I started to like it
C++ is just one of the most cleanest languages that are around
(although it has many quirks and is not what I would really call
“clean”, but it’s still “one of the cleanest”). It’s the only language
that solved the resource allocation/deallocation problem in the best
possible manner. See RAII vs. Garbage collection here:
On an unrelated side note, have you ever used Sinática Monitor
yourself? It sounds like a cool product, but I’m wondering how it
works. I have a similar project in mind that would work as a
Firebird-“Proxy” and sniff the communication between the client
application and Firebird. But Sinática even has info on server and I/O
loads, that really cool.
ED: I will try it on my ubuntu box if possible with wine
Thanks for your mail,
Mono’s 2.0 grand release has finally arrived.
See detailed release notes covering both the 2.0 launch and the changes since Mono 1.9.
Or you can go directly and download Mono 2.0 for your platform.
Also you must use Firebird DotNet Provider 2.5 with Firebird 2.1 .
Here are my notes on Ubuntu Intrepid
Today, after some days/weeks, I finally created some noticable (= not only internals) progress with Entity Framework provider for Firebird.
Now, the provider is able to use, map, call, … stored procedures (and functions [very experimental]). You can select stored procedures from database, map these to some operations in EF, create “function imports” etc. You can see this working on picture: