Recommendations for the creation of a database using Google maps



  • Hi everyone,

    Recently, I was searching online for a resource to help me understand the ardous task of creating a database for a map using MySQL. I am not familiar with writing code or even determining how long it would take to write the code that will function the way I want it to. In my online search, I came across a post from this forum that articulated and displayed examples against getting a college student to write your code. After learning this I have three questions, how long would it take to get familiar with MySQL, how long would it take for an experienced person v. a novice person to complete this process, and what is a reasonable fee (flat rate or hourly) to contract someone to assist with this project?

    Thanks to all who have suggestions.



  • @noob-coder said:

    what is a reasonable fee (flat rate or hourly) to contract someone to assist with this project

    You won't be able to find people to do a flat rate if you don't have detailed requirements worked out.  Unless you've delt with programming contracting get ready for some sticker shock when you do get hourly/flat rates.



  •  About five to ten years' worth of experience.

    What, your excuse for a client is asking you "make me something just like google maps, except I don't really want to pay much or have any clue what it takes to complete a project like that" ?

     

    You may have a webhost for your own site already, probably one with a LAMP installation, so it probably has PHPMyAdmin, which is a horrible web application for managing a MySQL server, so start messing about with that.

    @noob-coder said:

    I am not familiar with writing code

    Exactly what is your function in this whole situation, if you're not going to write any code?

     



  • Why MySQL specifically?


  • Discourse touched me in a no-no place

    @noob-coder said:

    how long
    21 Days.



  •  Without commenting on the bulk of the idea - at least try to use PostGIS (ie. PostgreSQL with Geo-Information-System add-ons).

    That should save you from re-programming (and debugging, and debugging, and debugging) of all the geometry stuff, at least - and you can use some indizes, instead of trying to roll everything on your own (to get acceptable performance).

    In fact, how about taking the openstreetmap database and code? Most probably it's much less work to add some small things to that beast than to re-build Rome (and all the rest) from scratch.



  • @PJH said:

    @noob-coder said:
    how long
    21 Days.
     

    That is an awesome link, sir.



  • @PJH said:

    21 Days.
     

    Good article - interesting reading! I thank thee!



  • @dhromed said:

    @PJH said:

    @noob-coder said:
    how long
    21 Days.
     

    That is an awesome link, sir.

     

     

    That is very old article.

     



  • @Nagesh said:

    That is very old article.
     

    I CAN STILL LIKE IT



  • @dhromed said:

    @Nagesh said:

    That is very old article.
     

    I CAN STILL LIKE IT

     

    We can ALL like it - despite its age, it's still very relevant.

     



  • Hate to sound like Captain Obvious, but knowledge of MySQL alone gives you zilch of a clue about GIS which those map applications really are.



  • @shimon said:

    Hate to sound like Captain Obvious, but knowledge of MySQL alone gives you zilch of a clue about GIS which those map applications really are.

    More to the point, isn't MySQL basically the only "major" database left without built-in GIS functions/data types? I'm pretty sure it is, but I'm too lazy to look.



  • @blakeyrat said:

    @shimon said:
    Hate to sound like Captain Obvious, but knowledge of MySQL alone gives you zilch of a clue about GIS which those map applications really are.

    More to the point, isn't MySQL basically the only "major" database left without built-in GIS functions/data types? I'm pretty sure it is, but I'm too lazy to look.

    No



  • OH OK THEN


Log in to reply