Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Which SQL database will you use?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #46
    Re: Which SQL database will you use?

    Originally posted by chadbrown View Post
    Is their any sql other that MySql that offers 64bit and is free?
    MS SQL 2008R2 Express is now available in both 32 & 64 bit. The max database size has been lifted to 10 Gb.

    See : http://www.microsoft.com/express/Database/
    Frank

    Tell me and I'll forget; show me and I may remember; involve me and I'll understand

    Comment


      #47
      Re: Which SQL database will you use?

      Originally posted by Clipper87 View Post
      MS SQL 2008R2 Express is now available in both 32 & 64 bit. The max database size has been lifted to 10 Gb.

      See : http://www.microsoft.com/express/Database/
      Darn, they waited until I decided to switch to MySql to make those changes.
      Win 10 64 Development, Win 7 64 WAS 11-1, 2, Win 10 64 AA-1,2, MySql, dbForge Studio The Best MySQL GUI Tool IMHO. http://www.devart.com/dbforge/mysql/studio/

      Comment


        #48
        Re: Which SQL database will you use?

        Hi;

        I have used RDBMS's since their inception in the 70's. There are only two I would use considering the following:
        Price
        Speed
        Flexibility
        Adherence to the ANSI Standard
        Portability
        Tools for design and deployment
        Usage (from large to hand-held SQL devices with full replication services)

        The absolute best for the last 8 years and probably for the next 8 years is PowerSoft's SQL Anywhere. My second choice would be MS SQL Server (any edition) but it is limited on its replication and portability but it is free and solid quality.

        Hope this helps
        Mike

        Comment


          #49
          Re: Which SQL database will you use?

          Originally posted by Finian Lennon View Post

          Almost all medical applications now have the capability for scanning and secure storage of documents/images in the back end. This will be a key feature of what I will be doing and so I talked to someone who is already doing this and has a couple of years of scanning to a back end already done. I was pretty surprised to learn that the total of scanned and stored (not necessarily scanned) items, in several tables, is already more than triple the maximum available capacity of MS SQL.

          Although the 10G sounds big based on typical dbf type uses, people move to a server database for the additional things they can do. So, if a business of any kind, medical office or not, is considering digital document/image storage, 10G looks pretty small. And most people, I think, choose MS SQL on the basis that they will never exceed the available capacity. As they say, never say never.

          Scanned files SHOULD be stored on the hard drive with a shared folder, NOT in the database itself which is a very inefficient way of doing it. As operating system has already created a file access structure for you.

          BTW in MS SQL 2008 it store those big files on hard drive and send to end user a link. see here http://msdn.microsoft.com/en-us/libr...QL.100%29.aspx

          Comment


            #50
            Re: Which SQL database will you use?

            Originally posted by chadbrown View Post
            Is their any sql other that MySql that offers 64bit and is free?
            SQLite

            Comment


              #51
              Re: Which SQL database will you use?

              I was programming in the early hours and ended up cutting a video on how I use NaviCat and MySQL in practice. Bit of a plug for my new Web Framework for SQL as well.

              http://www.screencast.com/t/MGRmN2FiY
              Steve Wood
              See my profile on IADN

              Comment


                #52
                Re: Which SQL database will you use?

                Steve,

                Are you using MySql 32 or 64 bit?

                Navicat Lite or Navicat Premium?
                Peter
                AlphaBase Solutions, LLC

                [email protected]
                https://www.alphabasesolutions.com


                Comment


                  #53
                  Re: Which SQL database will you use?

                  I have both 32 and 64bit on different computers, notice no difference.

                  I'm using Navicat for MySQL, there isn't a Lite version, I think you mean for version for SQLite.

                  The Premium version is for managing MySQL, SQLite, Oracle and PostgreSQL.

                  To summarize what I put in the video - I like this NaviCat program. It fits my style and need for speed. I especially like the Structure Sync and Data Sync. I could never figure out how to sync MS SQL between server and local. The Help file is almost useless and it takes a Google search to figure out how to create remote connections. It does not relieve you from learning SQL syntax and won't let you save code if the syntax is incorrect. That last point is a problem, I'd like to be able to save bad code so I can move on and come back to it later.
                  Steve Wood
                  See my profile on IADN

                  Comment


                    #54
                    Re: Which SQL database will you use?

                    Navicat has a free lite version. See attached image...


                    EDIT: Looking at the comparison matrix, I see you are using the Premium. The lite version doesn't support data/structure synchronization, etc...
                    Last edited by Peter.Greulich; 08-06-2010, 02:10 PM.
                    Peter
                    AlphaBase Solutions, LLC

                    [email protected]
                    https://www.alphabasesolutions.com


                    Comment


                      #55
                      Re: Which SQL database will you use?

                      I'm using NaviCat for MySQL, next tab over, Windows Enterprise version, $169.
                      Steve Wood
                      See my profile on IADN

                      Comment


                        #56
                        Re: Which SQL database will you use?

                        Toad for MYSQL is great, and is free.

                        http://www.quest.com/toad-for-mysql/
                        Land of the Free, Because of the Brave
                        Support our US Military

                        Comment


                          #57
                          Re: Which SQL database will you use?

                          I wanted to add another factor to the discussion. For about one month I have been investigating my options for a database back end for a health record system.

                          A big factor was the ability to have auditing capabilities.

                          I think, from a cost perspective, MS SQL 2008 may be better if whatever application you are building requires tracking what a user does when they are logged on. If you use MySQL you will need to use a third party application which will add cost. And there is also the learning curve for yet another GUI. Also, since Sun has been purchased by Oracle there is a really big push for the enterprise version of MySQL. This can be meaningful if you have mission critical data and at some point need to migrate to a different DB if the free version of MySQL is no longer supported.

                          Cheers

                          Comment


                            #58
                            Re: Which SQL database will you use?

                            Originally posted by koga101 View Post
                            if the free version of MySQL is no longer supported.
                            Free version will always (no matter what Oracle does) be here

                            MariaDB vs MySQL

                            Comment


                              #59
                              MySQL users beware

                              this is just a heads up for MySQL users because of recent action taken by Oracle regarding software that used to be open source
                              (No need to alarm, MySQL is still Open Source & free but it might be Oracles target in the no so distant future)

                              Read this post:
                              http://www.technewsworld.com/rsstory/70633.html
                              and this
                              http://www.technewsworld.com/story/70619.html
                              Last edited by mmaisterrena; 08-19-2010, 02:01 AM.
                              Cheers
                              Mauricio

                              Comment


                                #60
                                Re: MySQL users beware

                                It is also good to notice that Apple's iPhone 4 SDK license specifically prohibit the development of apps ported Adobes Flash, Sun's Java or Microsoft Silverlight/Mono.

                                (Big Companys are angry for each other also Oracle)

                                Ken

                                Comment

                                Working...
                                X