Some of you may be interested to know that the Valentina Relational Database Office server is now available completely free.
It is ODBC compliant so you can use it with VFP.
Oh, and it's fast....
I have used it on the iPhone with Real Basic as opposed to the inbuilt SQLite.
Dave
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921C7346@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Just to clarify.... using Web edition of RB as you can't generate stand alone iPhone apps ...yet.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of Dave Crozier
Sent: 14 December 2011 10:42
To: ProFox Email List
Subject: Free Valentina Database
Some of you may be interested to know that the Valentina Relational Database Office server is now available completely free.
It is ODBC compliant so you can use it with VFP.
Oh, and it's fast....
I have used it on the iPhone with Real Basic as opposed to the inbuilt SQLite.
Dave
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921C7374@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Dec 14, 2011, at 4:42 AM, Dave Crozier wrote:
> Some of you may be interested to know that the Valentina Relational Database Office server is now available completely free.
>
> http://www.valentina-db.com/
>
> It is ODBC compliant so you can use it with VFP.
>
> Oh, and it's fast....
>
> I have used it on the iPhone with Real Basic as opposed to the inbuilt SQLite.
Wow! What a blast from the past! I was an early Valentina user, back in the late 90s! It was the backend database for the first iteration of the leafe.com site. I filed more than my share of bug reports back then. I only switched to MySQL when they dropped their free version and I was too cheap to pay for it! Well, that and I wanted the fulltext search that MySQL had.
Back then Ruslan (the creator of Valentina) didn't have the means to run a mailing list, so I created and ran one for him - that was a couple of years before I started ProFox! I still maintain a mirrored archive of their current mailing list - you can search it at http://leafe.com/archives/search/valentina
-- Ed Leafe
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/60065FC4-9DF5-48DD-BC39-22B163F220E8@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Working on the basis that anything from David Crozir Esq is worthy of a
read, here is an article re differences between their database V
Database the Relational Way:
http://www.valentina-db.com/en/developer-articles/104-5-minute-technical-intro-to-valentina
Kind regards
Andrew Stirling
01250 874580
support@calcpay.co.uk
HMRC Accredited UK payroll program
On 14/12/2011 10:42, Dave Crozier wrote:
> Some of you may be interested to know that the Valentina Relational Database Office server is now available completely free.
>
> http://www.valentina-db.com/
>
> It is ODBC compliant so you can use it with VFP.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EE8BCF9.2090302@calcpay.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
This may be of use to Allen as I know he doesn't like setting up SQL servers such as M$SQL etc because of the access authorisation levels required.
Dave
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf Of Andrew Stirling
Sent: 14 December 2011 15:13
To: profox@leafe.com
Subject: Re: Free Valentina Database
Working on the basis that anything from David Crozir Esq is worthy of a read, here is an article re differences between their database V Database the Relational Way:
http://www.valentina-db.com/en/developer-articles/104-5-minute-technical-intro-to-valentina
Kind regards
Andrew Stirling
01250 874580
support@calcpay.co.uk
HMRC Accredited UK payroll program
On 14/12/2011 10:42, Dave Crozier wrote:
> Some of you may be interested to know that the Valentina Relational Database Office server is now available completely free.
>
> http://www.valentina-db.com/
>
> It is ODBC compliant so you can use it with VFP.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BD031ECABF2B60499200AAB3DBB4A999921C7604@EX-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I was thinking that too. Thanks Dave
Al
-----Original Message-----
From: Dave Crozier
Sent: Wednesday, December 14, 2011 4:46 PM
To: profoxtech@leafe.com
Subject: RE: Free Valentina Database
This may be of use to Allen as I know he doesn't like setting up SQL servers
such as M$SQL etc because of the access authorisation levels required.
Dave
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/16AA46EBA97B485DA296F77491BF6B7C@gslredacer
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
>Working on the basis that anything from David Crozir Esq is worthy of a
>read, here is an article re differences between their database V
>Database the Relational Way:
>http://www.valentina-db.com/en/developer-articles/104-5-minute-technical-intro-to-valentina
From the article:
"Valentina does not require the creation of KEY fields - you can avoid the
headache of filling in unique values.
Each Valentina Table has a special RecID field, which provides a unique
number for a record of this table.
...
To establish the all important M:M link between these two tables, Valentina
offers a very special feature: the BinaryLink.
CREATE BINARY LINK PersonPhone(Person, Phone)
AS MANY TO MANY
...
Versus Primary Keys. RecID fields do not consume any disk space. Compare
this with a primary key with associated indexes.
...
If designed with the native Valentina Object-Relational way, you would
execute the same query with Valentina:
SELECT *
FROM Person JOIN Phone"
Okay, yeah, but nothing is free.
SOME space SOMEWHERE on the disk is being used to store those invisible
RecID values.
And, what special hoops do I have to jump through in my code during data
entry so that Valentina knows WHICH phone goes with WHICH person?
It sure isn't going to guess it unless I follow a pretty strict protocol
for the data entry.
Ken Dibblewww.stic-cil.org
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5.2.1.1.1.20111214205830.01f53318@POP-Server.stny.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Dec 14, 2011, at 8:02 PM, Ken Dibble wrote:
> "Valentina does not require the creation of KEY fields - you can avoid the
> headache of filling in unique values.
>
> Each Valentina Table has a special RecID field, which provides a unique
> number for a record of this table."
[snip]
> Okay, yeah, but nothing is free.
>
> SOME space SOMEWHERE on the disk is being used to store those invisible
> RecID values.
Funny, I had this exact same argument with Ruslan when I was using Valentina. My point was that Valentina tables simply had an autoincrement column that was automatically added, and which you couldn't get rid of if you wanted. His point was since they were offsets and not actual stored values, they were more efficient. Valentina records are fixed length, so to get RecID=99 the software only has to jump to the start of the file + (99 * rec length).
> And, what special hoops do I have to jump through in my code during data
> entry so that Valentina knows WHICH phone goes with WHICH person?
You create links between tables, and these are essentially triggers that establish the relationship. Those *are* stored independently, but you have no control over them.
Valentina is actually a pretty cool tool, but IMO there are better options out there, both in terms of capabilities, size, speed and openness.
-- Ed Leafe
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/D613DEB8-B464-409C-AA6F-A63512E64A19@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Ed
Which "better options" do you have in mind?
Paul Newton
-----Original Message-----
From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ed Leafe
Sent: 15 December 2011 12:57
To: profoxtech@leafe.com
Subject: Re: Free Valentina Database
On Dec 14, 2011, at 8:02 PM, Ken Dibble wrote:
> "Valentina does not require the creation of KEY fields - you can avoid
> the headache of filling in unique values.
>
> Each Valentina Table has a special RecID field, which provides a
> unique number for a record of this table."
[snip]
> Okay, yeah, but nothing is free.
>
> SOME space SOMEWHERE on the disk is being used to store those
> invisible RecID values.
Funny, I had this exact same argument with Ruslan when I was using Valentina. My point was that Valentina tables simply had an autoincrement column that was automatically added, and which you couldn't get rid of if you wanted. His point was since they were offsets and not actual stored values, they were more efficient. Valentina records are fixed length, so to get RecID=99 the software only has to jump to the start of the file + (99 * rec length).
> And, what special hoops do I have to jump through in my code during
> data entry so that Valentina knows WHICH phone goes with WHICH person?
You create links between tables, and these are essentially triggers that establish the relationship. Those *are* stored independently, but you have no control over them.
Valentina is actually a pretty cool tool, but IMO there are better options out there, both in terms of capabilities, size, speed and openness.
-- Ed Leafe
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/96D5B71C2B277647A0ECF548F1EBF527066725A870@UKFAWEXMB2.infor.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Dec 15, 2011, at 8:20 AM, Paul Newton wrote:
> Which "better options" do you have in mind?
Depends on the use case. For relational servers, PostgreSQL is my choice. For embedded, SQLite and Firebird are excellent. If you need both server and embedded, Firebird looks like a winner. For object databases, Cassandra kicks ass.
All of these are free (cost) and open source. They all perform at a level that exceeds Valentina, so why would I possibly consider buying a proprietary product like that?
-- Ed Leafe
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/299CEDC6-1DF9-4979-A9CA-6C49163E1D08@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.