<b>Daniweb:</b> "A new version (9.0) of PostgreSQL is in beta and ready for public testing. If version 9.0 lives up to its proposed feature list, then it is serious competition for MySQL"
I have a mysql db and I have an automation script which modifies the data inside once a day. And, these columns may have changed by an user manually. What is the best approach to make the system only update the automated data, not the manually edited ones? I mean yes, flagging the cell which is manually edited is one way to do it, but I want to know if there's another way to accomplish this? Just curiosity.
Imagine, hypothetically of course, that you are being commissioned to develop a full-fledged real estate website that includes:
1) a search engine with ajax/json autofill,
2) google maps and geolocation integration, google streetview,
3) user registration, login and account management
4) administrative panels to control data input
5) search results page
6) user statistics
7) property inquiry to allow internal messaging between users
How much would you charge? Suppose you are developing the most advanced and specific system in PhP/MySQL, and your total development time is roughly 1500 hours? Any suggestions?
In all shared hosting environments, one can be agnostic to the running OS. What happens in the case of Linode?
I know it allows pretty flexible Linux installations, but for starters, besides choosing a distro, does one need to do more Linux sysadmin stuff besides the basic web hosting (DNS management, MySql database creations, users ftp/ssh access/ backups)?
Does Linode have a module that would cover cPanel's basic features?
Does one need to install/start/upgrade each aspect of LAMP (software bundle)?
I want to log every time I run a certain type of command in the terminal. For example, every time I run:
sudo apt-get install [something]
I want to add [something] to a log file in my home directory that will look like the following:
[timestamp] [something]
2012-10-02 mysql-server
2012-10-03 ruby1.9.1
2012-10-06 gedit-plugins
2012-10-07 gnome-panel synaptic
What's the easiest way to make this happen automatically?
Today we announced that Oracle is the 1st commercial affiliate of the Immersive Education Initiative which starts today at Boston College. So, if you have an interest in using Java, MySQL, NetBeans, Glassfish and VirtualBox technologies and deploying them on to create 3D interactive or mixed reality learning and collaboration experiences for education or business use. Then, Watch this space for more updates on this pioneering new community work on the 3D Web.
I bury a good deal of my ideas for fear that I don't know enough about scaling web applications and high-traffic websites. That said, I'd like to know of any general topics to research in order to ensure that your web app doesn't break / slow down when you start getting to Twitter-level traffic.
I'm looking for research topics with, preferably, additional resources.
For example: Make sure you optimize SQL queries (see High Performance MySQL Optimization)
According to Tiobe, http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html
(not exactly reliable but still)
and just noticing around here.
I see less talk about SQL in general? Has there been a slump in web development that uses databases like Mysql, or Data Warehousing here recently?
Or have alternate solutions like NoSQL/CouchDB/MongoDB started to take over or what? or have I just been missing something?
I am from mac os x background. To control my apache, mysql, and php, I used to use MAMP tool available for mac os x.
On my ubuntu, I have installed all the required softwares but, I want a good UI tool to control my apache. To be specific, I change my document root too often, so I want a GUI tool to where I can just browse for desired document root, and restart the server.
Is there any such tool available?
For some reason domain.com/YYYY-MM-DD redirects to domain.com/var/htdocs/public_html
RewriteEngine On
RewriteCond %{HTTP_HOST} ^[^\./]+\.[^\./]+$
RewriteRule ^/(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteRule ^archive/index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^. /archive/index.php [L]
trying to get anything after www.domain.com other than index.php and archive/index.php to display mysql content on archive/index.php (by grabbing PHP Request URI). The browser URL should remain www.domain.com/YYYY/MM/DD/blog-title or www.domain.com/YYYY/MM/ to display all posts from YYYY-MM
Ikoula et PrestaShop collaborent pour simplifier le déploiement de boutiques en ligne
Et les rendre scalables en fonction de l'activité et du trafic
L'hébergeur français Ikoula vient d'annoncer un partenariat avec l'éditeur de la solution e-commerce n°1 en Europe (et open-source) : PrestaShop.
Le but est d'optimiser le déploiement d'une boutique en ligne pour la proposer, le cas échéant, « clef en main » - y compris pour les professionnels n'ayant pas ou peu de compétences (ou de temps) en serveur web ou pour installer et activer PHP 5.1+ et MySQL 5.0+.
[IMG]http://ftp-developpez...
Along the lines of patching...
While it is not 100% in our LOB, it might still be interesting for some of our readers:
The Oracle critical patch update Advisory for October 2012
You will find a very detailed List with links to patches and matrices on that overview page for products ranging from Database via E-Business Suite to MySQL.
Of course you can find patches for Identity Management, SOA and Weblogic also via the "Master Note on Fusion Middleware Proactive Patching - Patch Set Updates (PSUs) and Bundle Patches (BPs) [ID 1494151.1]"
1.How am I supposed to store data on server, using not only: databases,text files and images?
And how someone could implement storing data in fb's graph api http://developers.facebook.com/docs/reference/api/ , so when I go to: https://graph.facebook.com/19292868552 it shows me such data(how it can be stored? I guess it's not Mysql database)
PS. Link to article: http://jayant7k.blogspot.com/2009/05/how-facebook-stores-billions-of-photos.html <- How can concurrent users writing requests be solved(while storing data in text file).
I am planning to launch an e-store and after looking at the current trend/developer community activity and economic viability i have decided to use PHP+MySql for development.
I don't wish to use a CMS as I want more flexibility than they offer .
I am basically a .net Developer and have no prior experience in PHP development and am getting confused as to what IDE to use ?
Should i use a framework(which) ?
I'm a php/mysql guy, and have been trying to brush up on my frontend skills. So this weekend I made a four function calculator in javascript.
But when I started to work on the presentation, I found myself adding extraneous markup just to achieve what a table tag naturally does.
Just so we're on the same page, this is the intended layout:
789+
456-
123x
c0=/
It it possible to generate this grid using neither a table, nor extraneous markup?
Thank you.
Is there any good open source alternative to OpenBiblio that can be ran on hosting package I have from undisclosed hosting company that does not give out root access to the server. I have seen that Koha and Evergreen needs root access and does not meet compatibility standard on my hosting package. Is there any good open source ones that can be ran with PHP and MySQL and community maintained and updated?
This question already has an answer here:
How to find web hosting that meets my requirements?
5 answers
What I need:
a domain name,
10MB of disk space,
1GB bandwidth,
php+mysql
is there anyway I can get this all for under $1 a month?
I installed a WAMP package on a Windows 7 machine and everything ( Apache, php, mySql, phpMyAdmin) appear to have installed correctly.
However when I try to access localhost or phpMyAdmin via the browser, I get "Server Not Found". I've tried using localhost, 127.0.0.1 in the browser.
I've checked the httpd file it says "Listen 80". C:\Windows\System32\drivers\etc\hosts says "127.0.0.1 localhost"
Apache log file doen't show any errors.
Suggestions appreciated.
There have been many occasions in which I have had to setup Web Authentication for websites or particular web pages. In this article, I will tell you how I set up web authentication using PHP and MySQL and where the real power lies in this technology.
Les meilleurs cours et tutoriels SGBD : nouvelle mise à jour avec 18 nouveaux tutoriels
Bonjour à tous,
Une mise à jour importante vient d'être effectuée sur la page Cours SGBD.
18 tutoriels, cours et Docs ont été ajoutés (38 au total).
Des liens vers les pages cours des sous-rubriques SGBD (MySQL, SQL-Server...) font aussi leur apparition sur cette page.
Accéder à la page mise à jour
Merci à tous les contributeurs de cette page qui ne cessent d'enrichir les ressou...
<b>IBM Developerworks:</b> "If you're a typical PHP developer, it doesn't take a thorough review of past projects to pick out a telling pattern: In most (if not all) cases, you're probably getting PHP to talk to a database back end for all that dynamic data goodness; in 99 percent of those instances, you're using MySQL."
A common story. The marketing team from Company A recognizes the need for an internet presence. They hire a web designer who creates an awesome (read Flash) website and a web developer (PHP-MySQL) to do the coding.