Menu
▾
▴
Re: [mdb-dev] FW: Status of Write Support?
|
From: Peter <ze...@ru...> - 2009-10-24 21:07:52
|
I dont think implementing write support is worth the extra effort. Java Jackcess library is much more mature and provides write functionality - I dumped mdbtools in favor of Jackcess a long time ago, never looked back. > 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 >> >> > > ------------------------------------------------------------------------------ > 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 > |
