Managed DBF using X# language

This forum is meant for anything you would like to share with other visitors
User avatar
DexterZ
Posts: 28
Joined: Sat Dec 03, 2016 1:35 am

Managed DBF using X# language

Post by DexterZ »

Wazzup guys!

Been playing with X# using Managed Dbf and I'm loving it!

Managed Dbf

^ _^ Y
Kudos to X# Team
User avatar
wriedmann
Posts: 3773
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Managed DBF using X# language

Post by wriedmann »

Hi Dexter,

interesting project!

Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
User avatar
DexterZ
Posts: 28
Joined: Sat Dec 03, 2016 1:35 am

Managed DBF using X# language

Post by DexterZ »

Thank you Sir Wolfgang,

I created this project because I'm missing the per record navigation and manipulation of data under managed world most of available database engine are using Dataset only fecthed from connected database using whatever query language :lol:

By using X# and Managed Dbf in VS it looks like programming in CLIPPER 5.3 C :) :) L
User avatar
wriedmann
Posts: 3773
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Managed DBF using X# language

Post by wriedmann »

Hi Dexter,

please don't the "Sir" here - we are all in the same boat....

You should have seen that here that there is a Vulcan RDD and that the devteam plans to write their own RDD.
RDD stays per "replaceable database driver" and was introduced by late versions of Clipper (AFAIK in v5) - and in fact it is the same record based database access like your "Managed DBF".

Hopefully earlier or later the development team will present an open source DBFCDX driver for X# - otherwise many people (including myself) will not be able to move their VO applications to the .NET platform.

Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
User avatar
DexterZ
Posts: 28
Joined: Sat Dec 03, 2016 1:35 am

Managed DBF using X# language

Post by DexterZ »

[ Apology for the politeness -- can't break the habit :lol: ]

Hello Wolfgang,

I'm aware that there is Alaska++, Apollo, Harbour and of cource Vulcan.Net that is using their own DBFCDX driver in their database engine, but I haven't tried any of those, because I'm still contended using VFP at that time.

Your news just make my day, can't wait for that release, hopefully it breaks the DBF file size limitation of 2GIG ^_^ Y

Dexter Z
User avatar
Chris
Posts: 4949
Joined: Thu Oct 08, 2015 7:48 am
Location: Greece

Managed DBF using X# language

Post by Chris »

Hi Dexter,

Extremely interesting indeed! Do you have it available for download, or is it still under development? I'd love to give it some test to see how well it works and additionally speed test it against the current vulcan RDD :)

Btw, not sure if you know it, but X# also has a Clipper-compatible preprocessor, so you can even use USE, SET ORDER etc commands as well, it's just a matter of creating appropriate #command statements.

Chris
Chris Pyrgas

XSharp Development Team
chris(at)xsharp.eu
User avatar
wriedmann
Posts: 3773
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Managed DBF using X# language

Post by wriedmann »

Hi Dexter,

the big difference between the Win32 based RDDs and the Vulcan RDD (and later also the X# RDDs) is that they can used by any .NET language - from C#, VB.NET and any other.

There is only a wrapper class needed that knows how to deal with the xBase specific datatypes like float and date that are returned from the RDD.

Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
User avatar
DexterZ
Posts: 28
Joined: Sat Dec 03, 2016 1:35 am

Managed DBF using X# language

Post by DexterZ »

Hello Chris,

Managed Dbf is still under heavy development since I'm the only one developing the project, my own index file (ZDX) is still buggy incomplete and currently trying to replace it with a new one, but I'm already using this in production mode if my requirements doesn't need ordering or index file.

Chris I'm pretty sure it has no match to Vulcan RDD if using an index file :lol: but gathering records using LINQ without an index file I'm not sure :P but I'm hoping MDbf will be faster ( crossing my fingers ).

I'm very new X# and that news regarding the Clipper-compatible preprocessor is really really exiting, I believe there's no need to continue this project if X# has it's own BDFCDX engine out of the box and breaks the 2GIG table file size limitation.

Dexter Z
User avatar
DexterZ
Posts: 28
Joined: Sat Dec 03, 2016 1:35 am

Managed DBF using X# language

Post by DexterZ »

Hello Wolfgang,

That is really exiting and I think X# is the real future of xBase! the only lacking I think is some blogging tutorials and youtube X# introduction and video tutorials, I search youtube regarding X# but without a luck T_T

Dexter Z
User avatar
wriedmann
Posts: 3773
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Managed DBF using X# language

Post by wriedmann »

Hi Dexter,

we have started recently a documentation web site: https://docs.xsharp.it - maybe this helps a bit.

It is still incomplete and needs work (and we are waiting that Google adds it to the index).

Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Post Reply