mORMot Open Source

EMartin

Member

From: Buenos Aires - Argentina

Registered: 2013-01-09

Posts: 336

SynOLEDb or SynDbZeos ?

Hi @ab, I want your recommendation on which to use for OLE Db connections. My application need connect to customer databases and mainly executing stored procedures.

Thanks in advance.

Esteban.

---

Esteban

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,236

Website

Re: SynOLEDb or SynDbZeos ?

It depends on the db used.

But SynOleDb may be preferred due to less overhead.
But it has small support of stored procedures.

EMartin

Member

From: Buenos Aires - Argentina

Registered: 2013-01-09

Posts: 336

Re: SynOLEDb or SynDbZeos ?

What does it mean small support ? SynDbZeos has better support ? The use of stored procedures is for security reasons from our customers.

Thanks.

---

Esteban

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,236

Website

Re: SynOLEDb or SynDbZeos ?

"Smaller support" in the sense of "less tested", since we do not use stored procedures at all in our projects.
See http://synopse.info/files/html/Synopse% … l#TITL_101
and https://kevinlawry.wordpress.com/2012/0 … hould-too/

BTW I do not see how stored procedures enhance security...
By hiding SQL? Avoiding injection? This is not obvious - see http://solutioncenter.apexsql.com/secur … injection/
You can do the same (and even better) with an ORM, prepared statments, and a service / SOA layer.

Which DB are you using?

EMartin

Member

From: Buenos Aires - Argentina

Registered: 2013-01-09

Posts: 336

Re: SynOLEDb or SynDbZeos ?

Ok, this the history. Our product is a system for contact centers, when a communication (phone, SMS, email, webchat, facebook twitter, etc.) it is processing our custom BPEL may need query a customer information, the more common query is over a database (the web services are few), then they implement stored procedures for security and maintenance reasons. In our system I removed the use of stored procedures but they are widely used as integration mechanism.

May be you should take into account the stored procedures for integrations.

The databases used until now are: Oracle, MS SQL Server, MySQL, DB2, Informix, AS400, Postgres. The current system used RemObjects (using ADO) and now I am trying to use mORMot with Delphi ADO components but I am having troubles with memory growth.

I'll try to use SynOleDB  and see what happens.

Thanks.

Esteban.

---

Esteban