Menu
▾
▴
Re: [mdb-dev] FW: Status of Write Support?
|
From: Houston, D. A Sr C. M. U. T. <dio...@us...> - 2009-10-24 21:31:45
|
Hey Peter, Thanks for posting this. For my purposes I need C (or C++ may be OK), but if it has write support it certainly should be possible to port from this project to MDB Tools. I'll take a look at it and see how it will help. Thanks again, Dion On 10/24/09 1:28 PM, "Peter" <ze...@ru...> wrote: > 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 >> > > > ------------------------------------------------------------------------------ > 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 |
