topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 6:43 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: SnapDB: Really nice software  (Read 9489 times)

jumper

  • Participant
  • Joined in 2016
  • *
  • default avatar
  • Posts: 21
    • View Profile
    • Donate to Member
SnapDB: Really nice software
« on: May 28, 2016, 08:00 PM »
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)
« Last Edit: May 29, 2016, 08:05 AM by mouser »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #1 on: May 29, 2016, 12:48 AM »
what are you referring to?

jumper

  • Participant
  • Joined in 2016
  • *
  • default avatar
  • Posts: 21
    • View Profile
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #2 on: May 29, 2016, 04:24 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #3 on: May 29, 2016, 06:17 AM »
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

  • Participant
  • Joined in 2016
  • *
  • default avatar
  • Posts: 21
    • View Profile
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #4 on: May 29, 2016, 06:31 AM »
My apologies, I got here through a link in the software. I'm talking about SnapDB.

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,612
    • View Profile
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #5 on: May 29, 2016, 07:00 AM »
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... :tellme:

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #6 on: May 29, 2016, 07:14 AM »
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

  • Participant
  • Joined in 2016
  • *
  • default avatar
  • Posts: 21
    • View Profile
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #7 on: May 29, 2016, 07:43 AM »
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

  • Participant
  • Joined in 2016
  • *
  • default avatar
  • Posts: 21
    • View Profile
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #8 on: May 29, 2016, 08:00 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #9 on: May 29, 2016, 08:05 AM »
Excellent  :Thmbsup:

jumper

  • Participant
  • Joined in 2016
  • *
  • default avatar
  • Posts: 21
    • View Profile
    • Donate to Member
Re: SnapDB: Really nice software
« Reply #10 on: May 29, 2016, 08:24 AM »
ty