SQL on demand?
June 7, 2010 7:30 AM   Subscribe

Is there somewhere you can go to upload some tables (or import CSV files) and run SQL commands on it?

If you have a few tasks that require you to join tables and do various SQL type stuff, but can't install software on the local machine, can you upload data somewhere and run a few commands on it? Paid services (within reason) are okay. Any suggestions?
posted by metametababe to Computers & Internet (8 answers total) 4 users marked this as a favorite
 
I don't know of any SQL on demand type service, but depending on what you mean by "within reason" you can get an account with a web hosting company that provides MySQL access. Then you could use phpMyAdmin or some such to upload data and run queries on them if you didn't want to roll your own toolset. You can get these kind of services for less than $10 a month, I think.

BTW, why can't you install the software on the local machine? Not enough computational power? Or security privileges? If it's the latter, I'm not sure how happy the admins would be with sending data off-site either.
posted by kmz at 7:52 AM on June 7, 2010


Could you run Portable XAMPP from a USB flash drive? It has phpMyAdmin built in.
posted by bcwinters at 8:00 AM on June 7, 2010


FreeSQL?
posted by ChrisHartley at 8:03 AM on June 7, 2010


SQLite can import (very simple) CSV files and of course run SQL commands on the imported data. I haven't used the import feature of SQLite, but I've used it as a simple database for PHP apps.

SQLite isn't a SQL "server", it's a library that manipulates a single flat file. Hopefully your computer restrictions will at least allow that.

There is a command line version or some other GUIs for an interface.
posted by meandthebean at 8:08 AM on June 7, 2010


You could run, from a usb stick, OpenOffice Portable, which has lots of sql stuff.
posted by MonkeySaltedNuts at 8:22 AM on June 7, 2010


If you have MS Office installed already you might have a copy of Access on there, which will let you quickly build some tables and mash data between them.
posted by msbutah at 8:53 AM on June 7, 2010


You can run SQL queries against CSV tables, Excel files, Access DBS, and SQL DBS through Excel's SQL query tool.
posted by dfriedman at 8:55 AM on June 7, 2010


Here's info about Excel's query tool: http://office.microsoft.com/en-us/excel/ha100996641033.aspx

obviously you need excel installed for it to work.
posted by dfriedman at 9:04 AM on June 7, 2010


« Older Repurcussions of co-signing a student loan when...   |   Drying logs for rough furniture Newer »
This thread is closed to new comments.


Tags

Share