Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 4 of 4

Thread: Open up a dialog on MYSQL

  1. #1
    Member
    Join Date
    Sep 2013
    Posts
    102
    Thanks
    38
    Thanked 0 Times in 0 Posts

    Default Open up a dialog on MYSQL

    From what I have seen of MYSQl I was wondering why such foreign systems for a pretty generic architecture? Tables, essentially arrays, query's intead of methods or functions. There are more, but outside of the foreign jargon, is such a database necessary? It would seem a lot easier to just develop a database (not that hard of a project), and use a common HTTP interface for data transfer. I understand not everyone uses it, but the fact that so many do seems odd to me. I understand people don't always want to go back and re-invent the wheel. Still it would save more time making HTTP interfaces more powerful, rather than wasting our time with all these drivers and plugins for databases.

    Just jump in give me your two cents, it would be good for me to hear your opinions. Perhaps even play devils advocate, assuming I'm not by myself with these thoughts.

    Post Script: there are other places this might fight (like JDBC/databases thread), however, I don't nessasarly have a question I want to talk more on a large scale (theoretical), so I feel it works here best.
    Last edited by KAJLogic; July 12th, 2014 at 11:52 PM.


  2. #2
    Member Ada Lovelace's Avatar
    Join Date
    May 2014
    Location
    South England UK
    Posts
    411
    My Mood
    Angelic
    Thanks
    27
    Thanked 61 Times in 55 Posts

    Default Re: Open up a dialog on MYSQL

    You make a valid point - and what I can say is the old saying when it comes to
    I.T and software development. Most programmers are lazy. Now do not take that the wrong way.
    All programmers are brilliant - but (as you said) there is no need to re-do what is already there written
    for us.

    The saying "if it isn't broke don't fix it" never sounded more plausible here. MySQL has been around for a fair
    few years - and being one of the most popular tools in LAMP development - I really cannot see it going away
    anytime soon. Look at the video games industry.

    Assembly was the #1 for all games on consoles at one point. It took decades for game developers to switch to
    a higher level language which was C. Then it took even longer for them to make the transition to C++ (which seems
    the norm in our day and age). It would take a bigger slice for all development teams of all AAA games to switch to
    a managed language (C# and/or Java) because there are so many developers well versed in C++ and Lua - plus
    most of the 'older' code written in C more or less works on a C++ compiler with minimal effort.

    I do understand your reasoning - and believe me there are others like it around - me included - it would take a major
    push for any syntactical change to happen - but you never know

    Wishes Ada xx
    If to Err is human - then programmers are most human of us all.
    "The Analytical Engine offers a new, a vast, and a powerful language . . .
    for the purposes of mankind
    ."
    Augusta Ada Byron, Lady Lovelace (1851)

  3. #3
    Super Moderator
    Join Date
    Jun 2013
    Location
    So. Maryland, USA
    Posts
    5,120
    My Mood
    Mellow
    Thanks
    186
    Thanked 658 Times in 645 Posts

    Default Re: Open up a dialog on MYSQL

    Thread moved to an appropriate place for discussing what could or might be rather than what is.

  4. #4
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,301
    Thanks
    181
    Thanked 824 Times in 767 Posts
    Blog Entries
    5

    Default Re: Open up a dialog on MYSQL

    tables, essentially arrays
    Sorry, but to be brutally honest this statement alone suggests a fundamental lack of understanding of a what a database truly does. Normalization, primary and foreign keys, indexing, transactions, column/row locking, query optimization, inner/outer joins, referential integrity, manage data spread across multiple-servers, security, and a whole lot more. A database is a lot more than a 'bunch of arrays'.

    It would seem a lot easier to just develop a database (not that hard of a project), and use a common HTTP interface for data transfer
    I recommend then, to give it a try. There are API's that do this with several different underlying databases, but one must take into consideration not only in transferring secure data but also protecting from insecure transactions

Similar Threads

  1. open dialog
    By javabegin in forum What's Wrong With My Code?
    Replies: 2
    Last Post: February 27th, 2014, 06:26 AM
  2. open multiple text file to input to mysql
    By csharp100 in forum JDBC & Databases
    Replies: 2
    Last Post: November 26th, 2012, 08:58 PM
  3. File open dialog box
    By Padmahasa in forum File I/O & Other I/O Streams
    Replies: 2
    Last Post: October 26th, 2012, 08:39 AM
  4. Replies: 1
    Last Post: August 3rd, 2012, 11:46 AM
  5. Facing problem with open modeless dialog from modal window
    By Divya in forum Java Theory & Questions
    Replies: 1
    Last Post: May 14th, 2009, 03:18 AM