SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    FreeBSD The Power to Serve silver trophy pippo's Avatar
    Join Date
    Jul 2001
    Location
    Italy
    Posts
    4,514
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Postal history database

    Hi,
    a friend of mine asked me to develop for him a database to organize his postal history documents.
    Basically he had many letters of different epochs and he wants to be able to classify them.
    In particular every document needs to be classified as:
    - stamps, optional
    - postal marks, source marks and destination marks
    - postal office name
    - date
    - etc

    I will have two databases.
    One that will contain for example all stamps and all marks catalogued.
    A question, is it very bad to store images inside the database ?
    I ask this because if I want to send to my friends the archive updated with new stamps/marks I'd like to send to them a unique file.

    Another database that is the archive ( ie the collection ) of my friend.
    I want to be able to give the application to other friends,
    but they will have in common only the first database.

    The tools that I could use are:
    - ms access
    - visual basic 6

    my knowledges are:
    - v.b. 6
    - php/c/c++
    - a bit of mysql

    I was thinking to have a GUI developed with VB.
    I was thinking to use ms access ( never used it, though ),
    but I have many doubts on how I can make a relation between db1 (stamps/marks/pictures) and db2 (my friend archive).

    I hope I was a bit clear, eventually you can ask me for details...;-)
    I'm a bit confused, please enlight me ;-).

    Thank you,
    [img]images/smilies/smile.gif[/img] Andrea
    Mr Andrea
    Former Hosting Team Advisor
    Former Advisor of '03

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,290
    Mentioned
    122 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by pippo
    One that will contain for example all stamps and all marks catalogued.
    A question, is it very bad to store images inside the database ?
    I ask this because if I want to send to my friends the archive updated with new stamps/marks I'd like to send to them a unique file.
    Quick answer: Yes.
    More involved answer: It really depends on the DBMS and the power behind it. If you're going to use access, I would suggest instead a link system that will allow you to keep the images outside the database.

    Quote Originally Posted by pippo
    I was thinking to use ms access ( never used it, though ),
    but I have many doubts on how I can make a relation between db1 (stamps/marks/pictures) and db2 (my friend archive).
    You could create link tables in db2 which would point to db1. How this would work for you to drop a new version of the database I'm not sure. You may want to just create some sort of update system that will update the stamp and mark tables through some SQL statements and moving of images via FSO.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •