SnapDB: Really nice software

[jumper]

Hi, great idea. I've been looking for something like this. I'm using VS 2015 and just want a small database for a program I'm writing.

I'll let you know how it turns out.

jumper

(new member)

[mouser]

what are you referring to?

[jumper]

It's hard to know what to say without repeating what I wrote previously. I'm a software engineer and I've been looking for a flat-file database for a project I'm working on. I've never worked with database and I'm terrible with SQL queries.

Hope this explains things

[mouser]

What I mean is.. It's not clear which program you are talking about -- you've posted this message in a forum section that covers all of the programs written for our NANY 2011 event, and you haven't said which program you are referring to.

[jumper]

My apologies, I got here through a link in the software. I'm talking about SnapDB.

[Ath]

Well, AFAIK, SnapDB is an application for storing collections of data in a flat-file 'format', not using a real dbms or database.

For your purpose I'd search google for an embedded database for vs2015, or resort to storing stuff in .xml file(s), as the .net framework has very good support for xml. Most other solutions use sql for managing their data, from SQLite (small, embedded) to SQL-server (small to enterprise size clustered databases), and open source solutions like MySQL or PostgreSQL.
Oh, and when working on professional software projects, SQL is (in) your future...

[mouser]

My apologies, I got here through a link in the software. I'm talking about SnapDB.

Ok that helps -- I've modified the subject lines to reflect it.

Now to part 2 of the confusion:  Your subject says "Got odd results" but your actual posts doesn't seem to mention anything about odd results.

[jumper]

Thank you ATH, I appreciate the info. Of the databases you mentioned, if I were to choose, I would go with SQLite. Plus, I'm already working with XML files in my software, but I've read where if it gets too big, it would be slow. Of course I don't know because I've never tried it.

[jumper]

Ok that helps -- I've modified the subject lines to reflect it.

Now to part 2 of the confusion:  Your subject says "Got odd results" but your actual posts doesn't seem to mention anything about odd results.

At first I thought I had found an "issue" with the software. I opened the file with notepad++ and it looked "odd". It appeared like the first two fields were both in column. And all the other fields looked like they were inside one column to the left. Here is what it looked like.

V 1.5.1
H Column 1 Column 2 Column 3 Column 4
W 80 80 80 80
O 1 2 3 4
P 674 397 572 365
F 1
R1 FirstName LastName PhoneNumber Birthday
R2 Joe Barnes 456-5555 may 16 1954

Now you can see why I thought it was "odd". But I tested it loading the file and it worked fine, But I did that in the middle of writing my message and forgot to change the title.

[mouser]

Excellent 

[jumper]

ty