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 - 6 articles available

Problems With Variables Not Being Passed To A Page
- Coding Tips | July 6, 2009, 2:59 pm

Variables not being passed most often happens because of one of two reasons. The first, and least likely, is when your PHP is corrupted. Fixing this would require a new PHP install. But the issue is likely that you do not have register_globals (php.ini) turned on.

---

12,000,000 Page Web Site
- 12 Million Page Web Site | July 5, 2009, 5:34 pm

When we developed the code to develop a business directory using our Enhanced U.S. Business Database, we knew its potential was huge. The goal was to make sure that every business we had a record of would have their own web page, and that alone let us know that we would start out with 11,000,000 web pages.

---

Converting CSV Files To SQL The Easy Way
- Working With Data | June 16, 2009, 2:34 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 | June 15, 2009, 8:57 pm

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 | July 29, 2009, 11:47 pm

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

---

Quickly Import Large CSV Files Into MySQL
- Working With Data | July 12, 2009, 6:56 pm

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 USPN Tech, All Rights Reserved