Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Okay. I have a better idea of what you're doing now. First of all, I'd recommend using MongoDB (or maybe even Redis) to store the politicians, not an XML file. Think about it. Many people will be doing searches. If you're searching and then I try to search, I'll have to wait for you to finish accessing the XML file before I can. Databases should be used instead of files if many people will be accessing the same data concurrently. Even if just one person is searching, the file must be opened &amp; closed every time you type something. Databases are much faster for this kind of thing, esp. MongoDB cause this happens all in ram. Just remember to put an index on what you're searching for, in this case, the politician's name.</p> <p>Also, how many politicians are there? If it's less than 5,000 or so, you could do what Facebook used to do with your friends: insert a JSON array of all your friends' ids on the initial page load. So, you could output upfront a JSON array of all the politician's names &amp; ids and then do the livesearch all on the client with JavaScript. Look into jQuery. <a href="http://ejohn.org/blog/jquery-livesearch/" rel="nofollow">http://ejohn.org/blog/jquery-livesearch/</a></p> <p>If you're going to use AJAX, I recommend using jQuery as well because it's easier and takes care of browser compatibility issues for you. (Your code might not work in certain browsers.) And jQuery is also very helpful for other event handling and modifying the DOM, which you're also doing in your code. So, you could use it for a lot of things you're already doing a more difficult way with JavaScript. Also, use MongoDB (check out MongoHQ for free hosting). I also think you'll find Sinatra much easier than PHP, and it's free &amp; easy to host on Heroku, and you can also hook it up to MongoDB. That's what I'm doing with acani <a href="http://github.com/acani/acani" rel="nofollow">http://github.com/acani/acani</a></p> <p><a href="http://webhole.net/2009/08/31/how-to-read-json-data-with-php/" rel="nofollow">http://webhole.net/2009/08/31/how-to-read-json-data-with-php/</a></p> <p>Scala or Node.js would also be faster than PHP or Ruby.</p> <p>Matt</p>
    singulars
    1. This table or related slice is empty.
    1. POLivesearch function with JSON
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USma11hew28
    1. USma11hew28
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks. I've learned how to parse JSON with php. But, now I sort of need to use PHP to dynamically output a result based upon what the user enters in the <input type="text" /> field.
      singulars
      1. PO
      1. USLance Newman
    2. COFor example, in my JSON file, I have the names, locations, and positions of 586 politicians. It's all hard coded. So, lets just say one of the names of the politicians in my JSON file is Barack Obama.
      singulars
      1. PO
      1. USLance Newman
    3. COHow do I make is so that if a user enters "Bara" or something similar to that in the input field, that it will automatically display Barack Obama's name along with his location, position in a division right under the <input /> tag
      singulars
      1. PO
      1. USLance Newman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload