Questions tagged [mysql]

If your question is explicitly for the MySQL database (server or client). Targeting "any" database, rather use the 'database' tag.

Filter by
Sorted by
Tagged with
2
votes
1answer
23 views

Creating a cache for MySQL

I'm looking to create a cache for MySQL. The issue is I have a relatively large table (hundreds of millions of rows) and there are a lot of fields associated with each row. The table gets probably ...
3
votes
3answers
614 views

Software/library for generation and real-time updating of network graph (nodes and edges) on website with MySql data

I am building a site where people submit pieces of data that are essentially nodes and edges, stored in a MySql database through PHP. I want to represent the data through network graphs (nodes and ...
4
votes
2answers
298 views

SQL tool that can use query result sets as temporary tables for further analysis and set operations?

For examples, lets say I need to do set operations and joins on below result sets from 3 different SQL queries: I don't want to write a composite query with subqueries, or use temporary database ...
4
votes
1answer
131 views

Database/Scripting Language suggestion for a project involving heavy inserts? [closed]

I am looking into a project which involves large number of inserts daily.I will have a list of user's (for example a user set of 500k ) , for which I need to monitor daily certain activities ...
3
votes
2answers
2k views

Program to import a Microsoft Excel spreadsheet into a MySQL table

I am looking for a program that can: import a Microsoft Excel spreadsheet into a MySQL table support cells containing line breaks support cells containing ' (and if possible any other character) If ...
3
votes
1answer
214 views

Automatically Backup MySQL Database and PHP Files on localserver

I have a web application that runs locally (in a local network). The application is PHP based and I am using WAMP server. The computer where WAMP is installed is always running. Is there any free ...
4
votes
3answers
13k views

Opensource PHP reporting tool

We are using an application developed by our internal team from last 2 years. It is ERP like application. Now the data is increased to such extent that we can't figure out the analytics from data. So ...
6
votes
6answers
563 views

Is there a MySQL interface that doesn't use PHP?

phpMyAdmin, SQL Buddy, and Adminer all run on PHP. I'm on a Python Debian server and I'd rather not install PHP. Is there a mySQL interface that doesn't require PHP?
2
votes
3answers
131 views

RDBMS for newbies in IT

I need to teach my two interns how to use RDBMSes in general and "standard" SQL during their free time, using the outdated windows notebooks we have laying around. They come from math courses and have ...
10
votes
5answers
260 views

PHP editor with live view for Mac

I'm a rookie PHP programmer and want to find the easiest way to use PHP editor that has a live preview functionality built in. I have a server where I currently test out my new found skills, but ...
11
votes
4answers
691 views

PHP/MySQL based forum with Facebook/Twitter/Google+ logins

I am in lookout for a forum that gets installed on an Apache-based server (like WordPress does). The following features are desirable: No ads Fully customisable or an option to choose from various ...
8
votes
5answers
7k views

OS X MySQL client?

I'd like to have a nice GUI for MySQL on OS X. The app must: Support connecting to external databases Support tunneling over SSH Show a nice GUI for editing and creating table schema Give access to a ...
17
votes
3answers
15k views

MySQL client for iOS?

I'd like to be able to manage my MySQL databases from my iPad. I currently use Sequel Pro on my Mac, and I love it. The app must Support connecting to remote databases Support tunneling over SSH ...

1 2 3
4