using SQLite for C# on xbox 360 xna as a local database

[jeffery]

I was thinking about using SQLite on an xbox 360 xna game but wish to
know if it has some of the same features as SQLite minus a few like it
has queries but does still have same limitations.

[Kevin Gadd]

I previously used SQLite on the XBox 360 for XNA and it worked fine.
Your biggest concern will be garbage; it produces a *ton* of garbage
which will cause lots of GC pauses. You can alleviate some of this if
you're willing to hack on C#-SQLite yourself to introduce pooling and
other basic techniques, or by only using it during load screens.

-kg

[jeffery]

I will only use it to load content mostly and store character and
campaign data and kevin has made some code I found where he does tests
on the database but if i used it for my special in-game editor and
only during loading screens will i be safe?

Im thinking about a codeplex or google project or both for using this
dll and I think its going to be a great addition to something to tell
members about do you think you want to help me? I will be focusing on
garbage collection issues mostly but have any sample commands in c#
for using the c# dll file? I have used databases but I see a sql
command when i import it into my sample xbox xna project for testing
do i use an insert command to insert into a database? Can you walk me
through simple c# code to properly handle the data? I will worry about
garbage collection later but I just need the basics now.

> > has queries but does still have same limitations.- Hide quoted text -
>
> - Show quoted text -

[jeffery]

Wait kevin? I could do some modification to your original code but I
will end up posting some working source for open source for people
trying to do xna xbox databases since their are not really much
options besides SQLite i've seen so far. I will want to save a single
database file directly unless you can help me come with a better
solution but Im a little organization prone so I will finish a project
most times unless too big to finish by myself. But I think if you show
me some simple SQLite commands I could probably help you out.

I have worked in c++ (fair amount from pointers to dynamically created
c++ variables) still havent worked with a gui in c++ but do know how
to implement one,python, vb.net, c#, html, asp.net, a little php, some
css, some javascript, a fair amount of vbscript.

So im fairly certain it will work out for the better if you were to
help me. I like to use a modular approach when programming and make my
code extensible.

> > - Show quoted text -- Hide quoted text -

[jeffery]

No edit button. I meant to say above I can program neatly most times
and stay on task until completion but can you reference me on how to
use it in a simple xna project?
P.S. if you have sunburn it would make trying a dynamic database
loading project/gui for xna databases a lot easier because even though
editor on windows xna the properties applied to scene/scene object
work on all platforms. So that might make people jobs in programming
games easier in the future.
Heres my sunburn xna sample starter projects codeplex page:
http://sunburncustomsamples.codeplex.com/
Try as a test to loading some objects using the database dynamically/
saving data to it.

I could do it myself but need some help on referencing in c# and will
rewrite your test code for xbox 360 if you provide help on that too.

[jeffery]

Well im using sunburn so some of the content parts will be alleviated
because it has instancing built into its libraries.