On occassion we will post some tips of the trade here. We work with large amounts of data, which we also sell here, and these tips are based on our daily work with 10 Gb CSV files, updating, replacing, and adding records.

We will also show you how you can develop a database-driven site that gets organic Search Engine traffic that you can turn into a profit. From queries, CMS, PHP, MySQL, cURL, mod-rewrite, and a ton of other tips will be found here. 

 

Recent Articles - 4 articles available

Converting CSV Files To SQL The Easy Way
- Working With Data | January 18, 2010, 11:24 pm

Managing your data, including importing data into a database for use on a web site, sometimes requires the right tools to di it quickly and efficiently. In the past we provided our customers various database formats, including CSV and SQL. But with the right tool you can now convert your raw data yourself.

---

Mod Rewrite For SE Friendly URLs A Practical Example
- Coding Tips | January 18, 2010, 3:10 am

We get a lot of questions about how to use Mod Rewrite on their Unix Platform web site, so they can eliminate query expressions in their url and make it Search Engine Friendly. (From query.php?keywords=mod rewrite to mod rewrite.htm)

---

Read This Before You Buy A Database
- Database Notices | June 15, 2009, 7:45 pm

We have been in the datamining and data management business since 1992. In 2006 we decided to open our market to the Internet with both good and bad results.

---

Quickly Import Large CSV Files Into MySQL
- Working With Data | January 18, 2010, 10:06 am

How many times have you tried importing large amounts of data into a MySQL database. How many 300 Second timeouts have you gotten? If you are using PhpMyAdmin, not only is it a race to get the program to import 100,000+ records, but you have the upload time to consider. 

 

---

Copyright © 1993-2009 ZattaMedia, All Rights Reserved