msaccess alternative

Discussion in 'OS X and OS X Apps' started by sonja athene, Apr 4, 2005.

  1. sonja athene

    sonja athene Member

    Joined:
    Jun 18, 2004
    Messages:
    60
    Likes Received:
    0
    Location:
    Makati Manila Philippines
    hello

    does anyone know any alternative for msaccess?
    i've heard of filemaker pro but i don't master it. i need someone or something, or somewhere to teach me filemaker.
    as for PHP or MySQL or Perl, i have no idea what these are and if they are any better than Filemaker Pro.

    please help me decided on what is the best programming database thingy. thanks.
     
  2. Dave_D

    Dave_D Active Member

    Joined:
    Jan 25, 2005
    Messages:
    2,113
    Likes Received:
    0
    Location:
    Ortigas Center, Pasig
    MS Access is a relational database program. Filemaker is it's traditional Mac counterpart. If you want to make personal databases that doesn't need to scale up to enterprise requirements, you'll be fine with Filemaker.

    As to your other queries, try the following on google;

    What is PHP?
    What is SQL?
    What is Perl?

    It would be better if you can give us some more information in what kind of database you intend to make so others can give you better information which might suit your purpose.

    Of course for enterprise purposes, I would always use SQL. Access and Filemaker will not cut our requirements for robustness and scalability. I would use PHP to generate dynamic content and PERL to handle some back-end (server side) functions.

    Good Luck.
     
  3. spiderman

    spiderman Member

    Joined:
    Apr 12, 2004
    Messages:
    197
    Likes Received:
    0
    Location:
    Manila, Philippines
    4th Dimension is one alternative.
    A lot of samples in their site. Theres even a tutorial if you want to learn programming in 4D.

    www.4d.com
     
  4. maitani

    maitani Member

    Joined:
    Apr 10, 2004
    Messages:
    88
    Likes Received:
    5
    Gender:
    Male
    Location:
    Las Piñas
    If you do not need to share info in a network and have relatively simple needs, take a look at Panorama V. It is said to be easy to use and powerful enough for novices.

    Panorama V is free to download, and you can use it free forever for up to 250 records. Otherwise, it costs $300--cheaper than all other alternatives. Try it, it may be all that you need.

    [Edited on 4-5-2005 by maitani]
     
  5. butchm

    butchm Member

    Joined:
    Apr 8, 2004
    Messages:
    103
    Likes Received:
    1
    Location:
    Quezon City
    if you're a programmer, or wish to do primarily development work, you can look at 4D or MySQL + PHP.

    If you're running a business or organization, and want to organize your information with minimal programming, you can look at FileMaker.

    When you download a trial verison FileMaker (www.filemaker.com) it comes with a tutorial and sample applications you can customize.
     
  6. booblanco

    booblanco Active Member

    Joined:
    Mar 29, 2005
    Messages:
    5,485
    Likes Received:
    0
    Location:
    Paranaque
    I'm looking for help on FilemakerPro7 and I was wondering if there's somebody here who's familiar with it.

    I'm currently modifying the downloadable business_tracker.fp7 template to suit my needs and I don't know how to produce an output form document to add to the ones already included in the file (packing list, invoice, catalog, etc.).

    Please U2U. Thanks.
     
  7. macuser101

    macuser101 Member

    Joined:
    Apr 16, 2004
    Messages:
    32
    Likes Received:
    0
    Location:
    QC
    I think the closest thing to msaccess is 4D, it's a relational database that use scripts to control the flow of data. It's actually free for students.

    Learning SQL is very important if you want to pursue a career in developing database applications for SMEs or even enterprise. It is also used in web database applications.

    Filemaker Pro is usually used for home business or personal database applications.

    I like to form a group to develop applications for SMEs using a Mac. I wonder if anyone is interested. I am also just starting to learn and hopefully develop a full business application. U2U if interested.
     
  8. jino

    jino Guest

    MySQL and PostgeSQL are open-source databases, but they usually don't come with a GUI. PHP and Perl are progamming languages that can build programs that can access the database. I prefer PHP myself for Web development.

    For an Access replacement, your only option is Filemaker, only it can match the GUI tools that come with MS Access.

    macuser101: You want to form an IT outsourcing company that specializes in custom built Mac programs?
     
  9. macuser101

    macuser101 Member

    Joined:
    Apr 16, 2004
    Messages:
    32
    Likes Received:
    0
    Location:
    QC
    jino, I am still contemplating on forming an IT outsourcing company. Have to research the demand (local/foreign) and the capability of local talents. I prefer to go Mac base from start to finish.
     
  10. hoho

    hoho Member

    Joined:
    Apr 8, 2004
    Messages:
    279
    Likes Received:
    0
    Location:
    Here
    Here are some resources for you:

    PHP -> http://php.net
    Perl -> http://perl.com
    PostgreSQL -> http://postgresql.org
    mySQL -> http://mysql.com

    PHP = good for dynamically generated web pages. A great example of PHP is this board itself!

    Perl = for dynamically generated web pages, admin tools, etc. I've used Perl for writing billing programs, generating web pages and a ton of other things. Its also known as "the duct tape" of the internet.

    PostgreSQL = a very good Open Source RDBMS. It also has a very active developer community. I've used this for quite a few projects, one of the first ones was something I wrote for i-manila a long time ago.

    mySQL = probably your best bet, if you intend on hosting this locally on your Mac. It has Mac OS X installers! Not as SQL compliant as PostgreSQL, but its pretty darn close, and it has an active developer community as well so that may not even be a limitation soon.

    If you are planning on developing software that you can distribute to your friends, or even commercially, you will want a standalone database type software. One that does not need a server type of installation. FileMaker Pro falls into this category. There are a lot of good suggestions along this thread, but this still begs the question: What do you want to use it for?

    H
     
  11. jino

    jino Guest

  12. hoho

    hoho Member

    Joined:
    Apr 8, 2004
    Messages:
    279
    Likes Received:
    0
    Location:
    Here
    Oh cool! I didn't know that existed. Then again, I haven't really checked in on PostgreSQL since about 1999. I guess it is time to take another look at it.

    H
     

Share This Page

  • About PhilMUG

    Since the mid-1990s, PhilMUG (formerly the Philippine Macintosh Users Group) has grown to become not just the Philippines’ but one of the world’s foremost Apple user groups. Our online community brings together thousands of members from the Philippines and around the world for the latest news and discussions covering all Apple products and related hardware and software. Anyone can join PhilMUG, from newbies to experts, subject to our membership rules and guidelines.
  • Like us on Facebook

  • Buy us a beer!

    The staff works very hard to make sure that PhilMUG is running 24/7. Care to buy us a beer or help out with our hosting fees? We'd really appreciate it!

    Donate to us!