I always was of the thinking of maintain every thing in his place. (In Spanish we say "Shoemaker, to your shoes").
I always was of the thinking of maintain every thing in his place. (In Spanish we say "Shoemaker, to your shoes").
Doctor Codd defined in his studies, how the database should be independent in his implementation, of the language used to query or modify his content. His idea is the base of all SQL System.
But the enterprises that create and sell the DBMS, legitimately of course, are all the time creating artifacts that made the software "as more dependant as possible of his DBMS".
Is because of this, so the language for the stored procedures, triggers and so on, has not an standard.
I always run away of this systems that presume of have all the program logic on Database. This is, in my mind, an stupid extreme situation. This is like turning the omelet arround.
"The initial idea was make the programming independent of the databases and finally we get the databases independent of the programming language used for the IHM."
This ideas are, what makes me be on the lookout about the No SQL databases and very against of complications that are not standar in the DBMS.
Oracle? Oracle owns Java!!! Why they want complicate our existence?
[PD: Oh! Saying all this has made me feel very well. I had to do it.]
lol
Originally shared by Horácio Filho
Hello guys,
Is there a way to use object-relational databases in Delphi? I mean those databases which use member functions, member procedures, nested tables, varrays and so on :)
Thanks in advance.
Doctor Codd defined in his studies, how the database should be independent in his implementation, of the language used to query or modify his content. His idea is the base of all SQL System.
But the enterprises that create and sell the DBMS, legitimately of course, are all the time creating artifacts that made the software "as more dependant as possible of his DBMS".
Is because of this, so the language for the stored procedures, triggers and so on, has not an standard.
I always run away of this systems that presume of have all the program logic on Database. This is, in my mind, an stupid extreme situation. This is like turning the omelet arround.
"The initial idea was make the programming independent of the databases and finally we get the databases independent of the programming language used for the IHM."
This ideas are, what makes me be on the lookout about the No SQL databases and very against of complications that are not standar in the DBMS.
Oracle? Oracle owns Java!!! Why they want complicate our existence?
[PD: Oh! Saying all this has made me feel very well. I had to do it.]
lol
Originally shared by Horácio Filho
Hello guys,
Is there a way to use object-relational databases in Delphi? I mean those databases which use member functions, member procedures, nested tables, varrays and so on :)
Thanks in advance.
As we're at the level of gross generalisations... SQL's a great language - why avoid it? Yes, it has different dialects - big deal, so does Pascal. Unlike Pascal for the past 20 years though, in SQL-land there are multiple big vendors, multiple major open source implementations, plus an official, evolving standard, and together they drive the language on. Avoiding performant set-based (or partially set-based) code just because it lives in the database in favour of lame, slow procedural code because it lives outside seems silly to me.
ReplyDeleteMichael Thuma 'In general SQL simply allows to create types at run-time' - hardly, most implementations are more statically typed than Delphi Pascal. It's Delphi that goes full-on dynamic typing when it comes to data access, not the underlying RDMS...
ReplyDelete