From: Brian B. <br...@br...> - 2009-10-23 15:57:03
|
Hi all, I must confess, the biggest problem with the status of the project is a lack of time on my part. I have too much paid work right now (not a bad thing) to have time to work on it. The status of writing is more or less this: 1. "In place updates", those which don't require a page split, are working. 2. Row insertion has some code written, which takes CSV style data, packs into MDB format, does the page management (allocates new pages, writes the row pointers, updates the free list, etc...). The problem is we are missing some understanding of the MDB file format because Access/JET doesn't see the newly inserted rows. 3. Creating new tables and so forth is not even started yet, there are still a few too many magic values in the table structure to give a good estimate on when if ever this may be possible. My main goal I was pushing for was to create an "mdb-import" program that would take a CSV formatted file and import it into an already existing table structure. This goal is presumably not that far off, but requires some further research of the file format which is tedious work. SQL insert/update support would be a follow-on sometime after that. Brian 2009/10/23 Lenny Leblanc <lle...@ma...>: > Hey All, > > > > I joined this list years ago and did a little bit of work on the package in > creating a mdb-queries routine which allowed some work with the queries in > Access. > > > > My memory isn’t so great but I think the biggest challenge back then was the > ever changing file formats that access used and the developers had a hard > time keeping up. Combine this with the fact that all of this is considered > proprietary so Microsoft has no intention of releasing their file formats to > make life easier. > > > > I still see this project as being important to Linux adoption overall. > People have access databases and without a way of at least converting them > this is a major hurdle for Linux to overcome. Even if most people wouldn’t > use this command line tool directly, I can see the potential for this engine > to be used in GUI environments in the future. > > > > Anyway, just wanted to throw in my $0.02. Nice to see some traffic on this > list for once J > > > > -- > > Lenny > > > > From: Peter Benjamin Volk [mailto:pe...@dd...] > Sent: Friday, October 23, 2009 3:33 AM > To: Houston, Dion A Sr CPT MIL USA TRADOC > Cc: mdb...@li... > Subject: Re: [mdb-dev] FW: Status of Write Support? > > > > Hey, > > I tried to contact the original developers about a year ago but did not get > any reaction. In one of our projects we have a plan to continue to develop > the mdbtools a bit. We have not gooten to far with it since other things got > in our way. Seeing this project get back to live would be great. > > Cheers, > Peter > > Houston, Dion A Sr CPT MIL USA TRADOC wrote: > > Ooops, guess I sent this directly to Murray instead of the list... > Resending... > > Dion > ------ Forwarded Message > From: Dion Houston <dio...@us...> > Date: Thu, 22 Oct 2009 20:30:58 -0400 > To: Murray Collingwood <mu...@fo...> > Subject: RE: [mdb-dev] Status of Write Support? > > OK, well I'll first state my bias. The Jet database engine will always have > a special place in my heart. I still remember the excitement I had when > Access 1.0 came out (I had been doing database work since dBase II under > CP/M). Later I had the chance to work in the Jet database group which > provided my living for several years. So my opinion is by no means > unbiased. Jet, especially for the times, was an amazing accomplishment. It > really marked the first time a high performance database engine was > available essentially for free. > > MDB Tools is no Jet. Nor do I think it was ever meant to be. But I would > definitely say there is a place for write support if for nothing else than > interoperability. In my case I'm hoping to enable people to use the latest > and greatest data file formats with an older system. > > I've reviewed the code base and I believe it's a reasonable short term > project to at least provide a Create Table function and the ability to write > forward-only into that table. This is the minimal requirements that will > meet my needs. > > If anyone has an interest in this level functionality please let me know. > > Also, if any of the original developers are lurking around on this list, > thanks for all you've done so far! > > Dion > > > > -----Original Message----- > From: Murray Collingwood <mu...@fo...> > Sent: Thursday, October 22, 2009 7:43 PM > To: mdb...@li... <mdb...@li...> > Subject: Re: [mdb-dev] Status of Write Support? > > Hi guys > > I agree with Alex. Actually, I think this read-only ability may be part of > the plan to extract as much data out of Access as possible without the > ability to put it back. Frankly, I think it's a good plan. The sooner we > get rid of Access the better. > > Cheers > mc > > > 2009/10/23 Alexander Lehner <le...@ed...> > > Hi Houston, Dion A Sr CPT MIL USA TRADO, > > just wanted to let you know that I'm reading this mailing list for more > than 1 year now and got about 2 or 3 posts so far. > mdbtools development seems to be dead somehow; reading works for my usage, > writing - I don't know. > But I would not expect too much support for any further development. > Pretty sad for a cool project... > > Alex. > > > > > On Sat, 17 Oct 2009, Houston, Dion A Sr CPT MIL USA TRADOC wrote: > >> Hi all, >> >> I finally resolved my CVS issues with this project and have the latest >> source compiled for OS X Snow Leopard. I see that there is a write.c that >> apparently has at least some support for writing. >> >> I am new to this project, and noticed that there is very little >> documentation. My questions are: >> >> >> * What is the level of write support currently in the CVS tree? >> * How do you use it? (preferably a code snippet) >> * Are there any more detailed docs on the API design? >> >> My particular application is to convert multiple file formats to and from >> a particular MDB database format in a cross platform way. For converting to >> this MDB format I do not require random access, nor SQL, nor anything else. >> It would be nice to be able to create databases as well, but I can >> certainly place an empty database into a folder and just add the necessary >> table. >> >> Thanks in advance for any assistance, >> >> Dion >> > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > -- > Murray Collingwood > Focus Computing > p +61 415 24 26 24 > http://www.focus-computing.com.au > > > ------ End of Forwarded Message > > > > ________________________________ > > > > ------------------------------------------------------------------------------ > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > is the only developer event you need to attend this year. Jumpstart your > > developing skills, take BlackBerry mobile applications to market and stay > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > http://p.sf.net/sfu/devconference > > > > ________________________________ > > > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > -- > > Peter Benjamin Volk > > Project Lead > > > > DDEngine.org > > An open source project > > Phone: [+49] (0) 351 862 9566 > > mailto:pe...@dd... > > > > > > Bunsenstraße 3 | D-01139 Dresden | GERMANY > > *********************************************************** > > > > Diese Mail einschliesslich der Anhänge könnte vertraulich sein. Sollten Sie > nicht der beabsichtigte Empfänger dieser Mail sein, so ist jegliches > Verwenden, Offenbaren oder Kopieren der Mail und ihrer Anhänge untersagt. > Bitte informieren Sie den Absender und löschen Sie die Mail und deren > Anhänge von Ihrem Rechner. Vielen Dank. > > > > This email and its attachments may be confidential and/or privileged. If you > are not the intended recipient, any use, disclosure or copying of this email > and its attachments is prohibited. If you have received this email in error, > please notify immediately the sender by return email and delete this email > and its attachments from your computer system. Thank you. > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > |