Rapid Web Application Development Framework For MySQL
I am searching for a rapid web application development framework for the MySQL database. In particular I am searching for an equivalent to the Application Express framework of Oracle (http://apex.oracle.com/i/index.html) for the MySQL database. I need to create an interface that allows users to simply create records in the database (e.g. through forms) and must be able to support more elaborate functionalities such as creating wizards or providing different and customized views to the database. Ideally all this works in a web browser.
View Complete Forum Thread with Replies
Related Forum Messages:
Mysql Shuts Down During Rapid Execution Of Querys
I am using version 4.0.12-nt of MySQL and when I hit the enter key rapidly I can't connect to the database. The result is a message is returned to me from mysql that says I can't connect because the database is down. If I only hit the 'enter' key once (to execute the page that my queries are on(their are four queries on this particular web page)) my queries execute just fine. We have noticed that this only happens when we:
View Replies !
MYSQL + Web Development
I have used MYSQL with JSP by running a program/service called Resin on my computer for the purpose of a project. I was just wondering what I would need to do/have to be able to implement and make use of MYSQL into a page that that I have made and am going to upload to the web.
View Replies !
OSX For MySQL Development
Inviting opinions if OSX is a better O/S for MySQL development. I wish to install the latest versions of Zend Studio, MySQL, PHP, Apache... - with production hosting on Linux. Has anyone tried OSX with this combination and faced any issues? Do I need to also install Windows on my Mac for any purpose?
View Replies !
Mysql Development Files?
Where would I find mysql development files for mysql 4.1 and red hat 7? I know red hat 7 is old but that all I have for right now... I need the developer files specially those that deal with headers. I am just quoting from instructions I have for this application.
View Replies !
MySQL Development Process
I am a student working from a university and at present part of my research involves figuring out the development model for MySQL. Who actually does the coding for MySQL and if MySQL development is open to all how does one get involved?
View Replies !
Can't Connect To Mysql Server On Development Box
I am setting up MySQL on a development box. I have set it up and can connect from localhost, but I cannot connect from another computer on the network. I have narrowed down the problem quite a bit, but can't quite figure it out still. I am getting MySQL Error Number 2003 "Can't connect to MySQL server on 'server'. I know that the server is there because I can ping it. I am also running a webserver from that computer and I am able to access that just fine. I know that it is not a rights issue because if you try to connect with a user that doesn't have rights, MySQL will respond "Access denied for user: 'user@host' (Using password: YES)". I checked on the host machine and check that the following are true: - mysqld.exe is in the process list (in the task manager) - MySQL is running on port 3306 (the one I'm trying to access it from)
View Replies !
MySQL For Multi-platform DB App Development/use
I need to scale a database app I built in Excel to a real DB environment. The final DB app will be used on one PC in Windows at work, but I need to be able to develop and test on Macs AND Windows.Most of the development will be at home on my Mac, or on the road on my Mac laptop. 1.Is a MySQL database just one file that doesn't care what platform it's copied to and worked on, as long as I have MySQL installed on both platforms (presumably the same version)? Example: design a DB on my home Mac, copy the file(s) to my laptop, work on it on the road, copy the altered file(s) to my Windows PC at work, test and modify, copy back to my laptop.you get the idea.
View Replies !
Preferred Linux Version For Mysql Development ..
I am planning to perform some development on the mysql kernel, which i hope to submit to the group later this year. Would you please tell me if there is a preferred version of linux ... I am not fussed but I am about to re-org my computer anyway, so any preferences or endorsements would be welcome.
View Replies !
Good MySQL Administration And Development Tool
I got MySQL working on my Windows 2003 Server and found a program called Navicat (www.Navicat.com) to create my databases and update them, but it was a trial version and it ran out. I am looking for an administration/development tool similar to Navicat that uses GUI instead of command line but is Free or really cheap. If I had an extra $125 I would buy the Navicat, but unfortunately I dont, so I was wondering if there was a Free alternative?
View Replies !
Moving MySql From Development Server To Other Servers
I am using Dreamweaver with php, mysql and Godaddy for Hosting. I have a website developed that runs fine locally using the localhost for both the Web app and MySql. What is the process that I go to to move or export the databse from the development server to Godaddy's MYSQL server. I have not found an "export" function using MySQL Adminstrator, or MySQL Control Center.
View Replies !
Connecting To MySQL From REALbasic And Other Third-party Development Tools
I'm using MySQL 4.1.13 MAX on OS X 10.4.2. I'm having trouble connecting to MySQL on localhost from a couple of third-party graphical client interfaces running on the same machine. I have no trouble connecting from the command line using mysql. I also have no trouble connecting using Navicat 2005. But trying to connect to the same db server from REALbasic just doesn't work. I also use a development tool called Revolution Studio 2.6, which provides a graphical client for connection to databases, and it also doesn't work. Both of these tools connect to PostgreSQL and OpenBase just fine -- it's only MySQL that doesn't seem to work. I've confirmed the host, user name, password, database name, and port number, all without success. In Revolution, I keep getting the following error message: "There was an error in connecting to the database. Please check that the connection fields are correct. Revdb error: Client does not support authentication protocol requested by server, consider upgrading MySQL client."
View Replies !
Using Mysql In An C++ Application
i am using mysql in my c++ application and when compileing i get the following linker errors (mysql.h, winsock2.h includen AND linked): mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegCloseKey@4 referenced in function _my_win_init mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegEnumValueA@32 referenced in function _my_win_init mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegOpenKeyExA@20 referenced in function _my_win_init mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptReleaseContext@8 referenced in function "public: __thiscall TaoCrypt::OS_Seed::~OS_Seed(void)" (??1OS_Seed@TaoCrypt@@QAE@XZ) mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptAcquireContextA@20 referenced in function "public: __thiscall TaoCrypt::OS_Seed::OS_Seed(void)" (??0OS_Seed@TaoCrypt@@QAE@XZ) mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptGenRandom@12 referenced in function "public: void __thiscall TaoCrypt::OS_Seed::GenerateSeed(unsigned char *,unsigned int)" (?GenerateSeed@OS_Seed@TaoCrypt@@QAEXPAEI@Z).
View Replies !
Distributing MySQL With An Application
we have developed many applications in Access where we end up writing a VB or VBA front end and distributing the Access data repository with the app, where the app is hard coded to talk to the repository. I was wondering if there is any way to distribute a MySQL database along with an application (.exe or whatever) so that the app could talk to it and/or "run" MySQL when it is started (without requiring the end user to really know or care about MySQL). What I don't want is for the end-user to have to: - Install MySQL separately from my app, or - Manually run and stop MySQL to use my app I'd be okay with my APP installing MySQL alongside, and starting and stopping it as needed?
View Replies !
MySQL With StandAlone Application
I was doing a search on databases, when I discovered this site. I am trying to creat a test application, where people are asked questions, the responses are saved in a database, along with thier profile. The end users will be dumb computer users, they just need to install the app and take the test. Is MySQL right for this job ?
View Replies !
Using MySQL As A Backend For A Commercial Application
I've read the MySQL licensing material and what I've found online, but I'm still unclear about when I have to pay MySQL for a license. Scenario: I've created an application that stores some data in MySQL 5.0 (InnoDB table types). It connects to MySQL 5.0 via MyODBC. 1.) If I include MySQL 5.0 and MyODBC in the installer, do I have to buy a separate MySQL license for every copy of the installer I sell? 2.) If I include MySQL 5.0 and MyODBC in the installer but allow the user to use their own licensed copy of MySQL 5.0, do I have to buy a license for the unused MySQL? 3.) If I include MySQL 5.0 and MyODBC in the installer but allow the user to use SQL Express (a non-MySQL product) instead, do I still have to buy a license for the unused MySQL? 4.) Does not including MySQL 5.0 and MyODBC in the installer change anything for any of these scenarios? I would like to support MySQL as the backend for my product, but not if I have to pay ~$600 for every copy just to allow a user to use MySQL (not require).
View Replies !
Converting MS Access Application To MySQL
I have several MS Access databases that I need to scale up (need to support more users, speed things up and make it more reliable that a JET database). I have experience of developing Access databases, MSSQL 2000 and MSQL 2005 databases and some experience of MySQL databases. I'd like to migrate to using MySQL for all our databases both for cost reasons and possibly being platform independent. Converting/migrating/re-designing the database structure in MySQL doesn't worry me but I'm unsure about which way to go in developing the front end application for the databases. I do like MS Access, even as a front end to MSSQL due to the speed with which I can develop and modify forms, reports etc. into a complete desktop application and know I could probably still use Access as a front end to MySQL but I just wondered if anyone has any advice on alternatives for the front end application - is the only other real option a browser based app using something like PHP for the logic?
View Replies !
MySQL Dump Is Not Allowing Application To Run
I am creating a backup once per day automatically. The current size of the file is around 4.1 Gig uncompressed. The command that I use is as follows: mysqldump --opt -q -R -u username-p'passwd' dbname | gzip > /filepath/$(date +%F).sql.gz This takes around 25 - 30 minutes to fully backup the database. The problem that I have seen is that while this backup is occurring I cannot access my JBoss application. Oddly enough, I tried to access the database directly and everything is working fine, but any other remote user cannot access the database. I want to know a couple of things: 1) Is my backup command optimized or is there something else I can add to make it faster. Now I do need to backup the data, table structure, stored procedures, etc. 2) How can I conduct a backup that is more efficient where it does not interfere with the remote users?
View Replies !
Delayed Response From MySQL To VB 6.0 Application
I have developed a system using Visual Basic 6.0 connecting to a MySQL database. The system inserts new records, updates existing records and views all records in the database. When I do an insert record and save the record to the database,I have a Flex Grid that I use to view all records from the table in the database,even the newely added record I just added. However, when i do add a new record, it takes at least half a minute to see the record in my Flex Grid. This confuses the user and he/she thinks that the record did not save, where in fact it did.I had already put an feature to update the Flex Grid and I don't think that Visual Basic is the problem. I think the problem may be the delay in response from the MySQL database to the VB application. This is the only problem I am having with MySQL, but it's a lot better to manage and easier to use than Microsoft SQL Server or Oracle.
View Replies !
VB + MySQL Client Server Application
I would like to know about what the most important things to be installed in every workstation if I will used VB and MySQL using the ODBC driver. Is there a need to install VB, MySQL, ODBC Driver in all computers? If possible can you give simple snippets in configuring MySQL and ODBC in VB code.
View Replies !
Writing Multi-threaded Mysql Application
What I'm trying to do is to rewrite mysql client application (which calculates ISP dial-up customers' billing)into multi-threaded version. I'm looking for some resources on multi-threaded mysql application programming and it will be great if somebody knows some tutorials, samples and howto documentations on the web. I searched the web and didn't find anything related to mysql multi-threaded programming.
View Replies !
Mysql 4.0.13 Error Code 1064 In Another Application
I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as been okay until I tried creating moderators to my forum and then I got the following error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 My intuition is that because I start mysql as a service in win2k and so each time I log onto my Win2k Server, mysql is running already. I however log into win2k with username Administrator, while mysql root user has been changed to my name ola, I believe that user Ola has all the rights with the following setup string: Code:
View Replies !
How To Get An Application To Register A User With The MySQL Server
I am making a mail user agent, with Java and MySQL server, that is supposed to work on a LAN. I am a little confused. If a user has to sign up, its the root account that will have to grant the user privileges, for which connecting to the server as root is required (?) So I initially thought of writing a class which connects to the server as root and then creates the user as per the request. Is it wise, or is there any ohter better method, through which the Java program can connect to the server. I mean to ask if its correct to write a program which has in it the main root password(a program that is a part of the Java application). There could be problems, such as, a change in the root password..
View Replies !
Local Application Connection To Remote MySQL
I have managed to set it up on a remote server, I would like to know what' the best way to write an application, pref. in C++, that can connect to the remote DB over the internet. Basically, I hope to have a program running on a local computer collecting information and dumping it into an online MySQL database.
View Replies !
C# Console (exe) Application Crashes On Open Command (MySql)
I have problem opening an MySql connection from an win console application. I am using SharpDevelop as IDE. Previously I've been working with MySql through C# aspx and am new to writing exe programs in C#, so I assume that I might be missing something in the IDE / project configuration. I am successfully opening a connection and reading data from the table using adapter (window panel application binding to a grid), but when trying the code below in an console application the program crashes when calling the MyConn.Open(); function. The error message being: Exception MySql.Data.MySqlClient.MySqlException was thrown in debuggee: Unable to connect to any of the specified MySQL hosts. Open() If I break before the MyConn.Open(); function is called, the MyConn variable is filled with lot's of info looking ok to me, though I am not capable of knowing if any of it can tell me what leads to the crash in the next function call. Ive added the MySql.Data.dll to the project from the GAC list in the add reference panel. Further, in addition to the references, I only have an AssemblyInfo.cs file and the Main.cs file with the code below in the project I've reinstalled the MySql database trying different configurations etc, but whatever I have tried does not work. Has anybody else encountered this problem and or know the solution?
View Replies !
MySQL Open Source Application Components/plug-ins/add-ons
Perhaps someone might be able to tell me if there is a place to find MySQL opensource community application components/add-ons/plug-ins/contributions (whatever one might call them) which developers can reuse and modify to deliver MySQL applications faster? eg. something like a community download repository, or something to that effect. Would likely contain database definitions, queries, performance analysis tools, etc. Many open source products have this, I'm sure MySQL must, just feel silly that I can't find it.
View Replies !
Connecting To A Remote Mysql Server From A Java Application On Another Machine
i've a java application on a (remote/network) machine and mysql running on my local pc.other users who have access to that remote machine must be able to run that java application which will have to get data/send data to the server(/DB) on my local PC. i was able to run the application when its on my local pC using localhost in the connection string. But, now how do i set the connection string so that the java application accesses the DB (/server) from my local PC?
View Replies !
Off Line Development
I was wondering if there was a way to program a MySQL server and edit the tables, off line in a program such as ms access and then upload the changes, when you are able to connect to the server?
View Replies !
Development Question
We've got a few machines at home on a small network; my wife has set up the mySQL database on one of the boxes and I've been working on the php front end on another box. I know the ip's of all the machines, etc... but I'm not exactly clear on what I need to do to get my php site connected to the db. Running apache 4.2.3 (IIRC) on W2k for the php box, the box w/ the database is running same version of apache, I don't recall the mySQL version at the moment, and the OS is winXP.
View Replies !
Setting Up Development Area
Having recently acquired extra MySQL upon my hosting renewal I want to use one of them as a development area for PHP aspects. Now, the one I'm using at the present is for a forum and the way I see the results are via looking at the url page of the forum. How would I go about viewing said results "in-house", so to speak, in the MySQL for the development area? This is probably very simple for many of you but I am new to MySQL and the incorporation of it for the forum was done automatically by the hosting service.
View Replies !
Beginner Development Process
Whats the best way to develop mySql database to live server? I've work for many years with Access file based database and development was pretty straight forward: 1. design, develop, and test database on local server. 2. after fully tested, ftp up to live server. When comes to mySql management system, I'm not sure how to proceed. I've downloaded and learned how to use the control center and admin interfaces. I've even taken tutorials working at the command line. While this is all good its still all local how the heck do i get it up to a live server. I've read you can use admin tool to dump the data out, but once you've done that what do you do with it? And once you have it up to the server how do you get it back to your machine to back it up or work on it?
View Replies !
Db On Live Site And Replica On Development PC
I have a Db on my live site, I use DW to manage the site and phpMyAdmin to manage the mySQL Db, and I'd like to do the following: 1. Replicate the Db on my Dev PC, to modify then reset the live version on the site to match it. 2. Set phpMyAdmin config to look at the PC version of the Db when developing and the Live version when its up on the site. Hope these make some sort of sense - just new to the world of php and mySQL (actually an MS developer).
View Replies !
W/ Database Model Development/Design
I have a client who is asking me to duplicate the content of another's website but into a database. You can see the website at http://www.transtec.com/trans_by_vehicle.htm and choose any one of the domestic or import vehicle types and you will see the table(s) I am using to develop my database. As you will see there are automotive makes, model, engine specs, transmission, remarks (remarks about each transmission). I have laid out what I THINK is a table structure for my database and I would appreciate any feedback. The "Types" table is for import / domestic. Am I on the right track with this? I have put an image online for your review at www.atramember.com/rdm.jpg
View Replies !
C Development On OSX: Library Load Issues
I have code that has been working on OSX [not Intel] for at least two years. We now have an Intel Mac and I am trying to recompile and debug the code for it. I am NOT a Mac expert. The older versions just did whit I hoped they would. I have had two issues so far. I have been able to "fix" one: The following GCC command "works" but the resulting binary can not be debugged. gcc -Wall -ggdb -I/usr/local/mysql/include -o myProgram myProgram.c -L/usr/local/mysql/lib -lmysqlclient -lz GCC says that there are no debugging objects in the executable and that it is "Unable to read symbols for "/usr/local/mysql/lib/mysql/libmysqlclient.15.dylib" (file not found)." I found a web page that talked about adding "-framework CoreServices" to the compile line. That has allowed me to see the debugging info/set breakpoints, etc in my code but there is still a MySQL issue. GDB reports: warning: Unable to read symbols for "/usr/local/mysql/lib/mysql/libmysqlclient.15.dylib" (file not found). This is interesting in that if you look at the compile line I say "-L/usr/local/mysql/lib -lmysqlclient" but gdb is trying to find "/usr/local/mysql/lib/mysql/libmysqlclient". GDB seems to be adding an extra "mysql" dir in the "-L' path.
View Replies !
Graph Of Development Number Of Customers
Ok i have a table with the customers and their registration time. I cant figure out the sql to create a graph which: displays the number of registered customers per day in the past 30 days. I would know how to get it for one day, but have no idea how to do this effectively for the past 30 days without running 30 queries. How do i solve this?
View Replies !
Move Database From Development To Production Server
I have a mysql db that is currently on my developement server. I would like to move it to production. Can I just copy the nessecary files and move them to the appropriate location on the production server -- I don't want to have to recreate the tables, indexes and so on. I do not have direct acccess to this server, so it would mean teaching someone else to do the "right things", most of which I just figured out for myself.
View Replies !
GUI Application
I would like to know which is the most convenient and functionable GUI package for MySQL design and administration under Windows OR Mac OS X.
View Replies !
CORBA Application
i have a situation to build a large scale app,there are many of client to call insert and select method from a corba object,then the corba object operation on the mysql db,but i am a much newbie for carba
View Replies !
Portable Web Application
The client wants to be able to use a portable web application I built, with its own customized mini search engine, to be able to search using 3-lettered words instead of the default 4 set in ft_min_word_len However, the client wants the change to ft_min_word_len to be temporary, at application runtime, because the portable app will be housed within 1 or more servers where other applications will also be running, and they don't wish to change the MySQL default settings that will affect other applications.
View Replies !
Specification Vs Application
I need to display a large rate sheet that has a specific set range EG: 1-15, 20, 25, 30, etc (up to 150). I have three options in my head: 1. Specify these values in an "IN" statement in the query OR 2. Specify a subquery to see grab only things in the range OR 2. Use PHP to check each row before displaying. IE: Use Mysql Engine vs using PHP engine. Any thoughts? If you want more details, let me know.
View Replies !
|
TRACKER
