<div><div class="gmail_quote">On Sat, Jan 1, 2011 at 2:40 PM, Gary Briggs <span dir="ltr"><<a href="mailto:chunky@icculus.org">chunky@icculus.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Sat, Jan 01, 2011 at 01:26:15PM -0500, Robert Konigsberg wrote:<br>
> Hi,<br>
><br>
> I've started a github project for a script that merges multiple<br>
> OBD databases.<br>
<br>
</div>Cool. Something I've always wanted :-)<br></blockquote><div><br></div><div>What's that? A database merger tool or obdgps in github? :)</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
For what it's worth, if I were going to implement this, I'd use this<br>
puppy:<br>
<a href="http://www.sqlite.org/lang_attach.html" target="_blank">http://www.sqlite.org/lang_attach.html</a><br>
<br>
I'd open a connection to the main database I'm merging stuff into<br>
[creating a fresh copy of a previous database if I'm planning on leaving<br>
the originals intact], then using ATTACH to get the second database into<br>
the same connection.<br>
<br>
That way, you get INSERT INTO SELECT FROM for free. [sqlite's "SELECT<br>
INTO" equivalent]. Dunno if that'd actually help if I sat down and<br>
figured the logic all the way through, but it might be useful to you<br></blockquote><div><br></div><meta charset="utf-8">That's certainly useful, but at this point just reading/writing is doing the trick for me. What I'm doing is suboptimal in a few places, but doesn't really much matter for my needs -- code it first, optimize it later. :)<div>
<br></div><div>Hey qq, is this correct -- every field (other than trip, ecu and time) is a REAL?</div><div><br></div><div>Thanks, Rob</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Gary (-;<br>
_______________________________________________<br>
obdgpslogger mailing list<br>
<a href="mailto:obdgpslogger@icculus.org">obdgpslogger@icculus.org</a><br>
<a href="http://icculus.org/mailman/listinfo/obdgpslogger" target="_blank">http://icculus.org/mailman/listinfo/obdgpslogger</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Robert Konigsberg<br><a href="mailto:konigsberg@gmail.com">konigsberg@gmail.com</a><br>
</div>