Re: [nbos] Astro3 Experimental Build
Carl Hess
Mon Nov 16th, 2009

It's a nice little library, and it integrated with 2010 just fine.
Since all of my stuff was written for XML I'm re-writing my data adapters for SQLite. Fortunately, I have a great deal of experience with SQL databases, so the work is going quickly. There are a few tricks I need to learn for SQLite, but the documentation on the site Chris referenced is pretty good.
I didn't get much done this weekend aside from getting the libraries loaded, examine the schema of the new database and write a few SELECT queries to pull data. I will say that what previously took me 100 or more lines of code now takes less than 10. Once I figure out my INSERT INTO statements for Notes and GMNotes, I'll have the whole thing done quickly.
I'll send in another report after I insert some records into the Sector DB and load the sector back into AstroSynthesis.
Thanks!
-Carl
From: doggedboy-at-hotmail.com
To: nbossoftware-at-nbos.com
Date: Fri, 13 Nov 2009 19:18:30 -0800
Subject: Re: [nbos] Astro3 Experimental Build



















Thanks a ton! Iíll check it out tonight.



-Carl







From:
nbossoftware-bounces-at-nbos.com [mailto:nbossoftware-bounces-at-nbos.com] On
Behalf Of Chris Tavares

Sent: Friday, November 13, 2009 9:29 AM

To: nbossoftware-at-nbos.com

Subject: Re: [nbos] Astro3 Experimental Build







SQLite isnít supported directly by the .NET framework, but you
can get a third-party provider here: http://sqlite.phxsoftware.com/



No idea if it works in 2010.



-Chris







From: nbossoftware-bounces-at-nbos.com
[mailto:nbossoftware-bounces-at-nbos.com] On Behalf Of Carl Hess

Sent: Friday, November 13, 2009 8:26 AM

To: NBOS Software

Subject: Re: [nbos] Astro3 Experimental Build







I
messed with it a bit last night. I noticed an increase in sector size
converting from 2 to 3 (13k to 15k) and it didn't take too long. It did
take a while to open the file after it was converted, and I noticed that the
conversion process didn't save the file as AstroDB, but rather, with a .sector
extension as under 2.0. This is probably by-design, forcing the user to
explicitly save their converted, opened file, but it was a little confusing.









SQLite
is kind of a pain. The have a .dll that contains their functions, and I
tried to reference it using C# in Visual Studio 2010 (beta 2) but it was not
recognized as a valid library file. It's probably unmanaged C or C++, or
it could be that 2010 just doesn't support that kind of thing yet. I
half-expected a .NET library for SQL to be included, but it's not there. I'll
do some more research on the System.Data libraries and see if SQLite is
supported. I started to tinker with their command line utility but it got
late. I'm going to install SQL Server 2005 tonight and see if I can
convert the AstroDB file to .SQL and back. The documentation for SQLite
seems to indicate it's supported, but this may not be the best way to go for
manipulating the data in the sector and loading it back into the program.











Thanks
again for the beta opportunity.











-Carl









> Date: Fri, 13 Nov 2009 00:55:44 -0500

> To: nbossoftware-at-nbos.com

> From: support2-at-nbos.com

> Subject: Re: [nbos] Astro3 Experimental Build

>

>

> I'm going to make some tweaks to the converter to handle larger files

> better. The one main drawback of using a database is that it is slower

> writing to the database than it is writing to a standard file format. Of

> course, one of the reasons its slower because its more reliable. I

> anticipate in the actual v3 release, a lot of the saving will be done in

> the background. It also probably wouldnt hurt if there was some sort of

> progress status feedback on the conversion as well.

>

> The converter wasnt unloading bodies from memory after they were saved to

> the database, which is the normal procedure as a file gets saved, so thats


> whats behind the ram usage.

>

>

>

> At 04:24 PM 11/12/2009, you wrote:

> >I've noticed my sector file is double the size with the new file
format, tho

> >my original sector was only 2,394kb the new one ends up being 5970kb,

> >Attempting to reconstruct a 81MB sector file, noticed that Astro3 is

> >chugging at it at 3-5% of my CPU (Dual Core 2.5ghz) during the
conversion.

> >I'm waiting for the mem usage to reach around double the filesize
before I

> >shut it down. (this may take a but)

> >~~Richard~~

>

> _______________________________________________

> Nbossoftware mailing list

>

>













Windows
Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail
you.


_________________________________________________________________
Windows Live: Keep your friends up to date with what you do online.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010
_______________________________________________
Nbossoftware mailing list



Copyright © 2003-2007, NBOS Software. All rights reserved. 'Fractal Mapper', 'ScreenMonkey', 'Character Sketcher', 'Inspiration Pad', 'Fractal World Explorer', 'Goblin API', 'AstroSynthesis' are trademarks of NBOS Software. 'Dwarven Beserker' art by V. Shane.
Member contributed resources