SQL, database, informix, oracle, SQL Server
Quick Search for:  in language:    
SQL, database, informix, oracle, SQL Server,source code, code, sample, samples, program, programs, help, tutorial,tutorials, routine, routines, jobs, listserve, mailinglist, bulletin board, bulletin boards, programming,  snippet, snippets, control, controls, class, classes, module, script, Scripts, applet , email , mp3, reference, windows,  modules, file, files, subroutine, subroutines, function, functions, sub, Microsoft, Sun,  downloads, winapi, directx, msaccess, ocx, vbx, ado, dao, odbc, rdo,  vbscript, vba, game programming, dcom, ole, com, dna, jet, dll, win api, winapi,  dbgrid, database front end, certify, decompiling, decompiler, visual basic for applications,  variable, constants, data type, byte, boolean, integer, long, single,  double, currency, date, object, string, variant, sub, function, free,
   Code/Articles  |  Newest/Best  |  Community  |  Jobs  |  Other  |  Goto  | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
SQL Stats

 Code: 44,501. lines
 Jobs: 118. postings

 How to support the site

 
Sponsored by:

 
You are in:
 

Does your code think in ink?
Login





Latest Code Ticker for SQL.
Create thousand Data Base users quickly
By N.D.I.Samantha on 1/1


Numbers from String
By Jeff Michelson on 12/30


Number to words in a single query
By Joseph Varghese on 12/24


Click here to see a screenshot of this code!The Best Columns to Index
By Sherenato on 12/23

(Screen Shot)

Click here to see a screenshot of this code!SQL 2 String-lists comparison
By Mohamed EL-Zahaby on 12/18

(Screen Shot)

Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!

Affiliate Sites



 
 

About the Site and the Original Author


Technology behind the site

      Hi! My name is Ian Ippolito and I am the original creator of Planet Source Code.  It was first written with Microsoft Visual Interdev 1.0 and Microsoft Access.  The scripting is done with a technology called Active Server Pages (ASP) and is done using VBScript.  Currently it is running from Microsoft Visual Interdev 6.0 and Microsoft SQL Server 7.0, and I can guarantee that as technology changes, so will the technical foundation of the site.

How it came about

     The idea for this site came to me back in 1997, when I began looking for Visual Basic source code on the Internet.  I was frustrated by the lack of quantity of source code, as well as the amount of time I had to spend downloading .zip files which were of questionable quality and relevance to what I was looking for.  I thought it would be really useful if there was a site that allowed me to actually see the code before I downloaded it, and maybe even let me copy and paste it from my browser to VB, so I didn't have to go through the hassle of unzipping it.

     Thus www.Planet-Source-Code.com was born.  Back then sites that had databases were VERY rare (maybe a handful of them existed).  To put it in context, this was before most browsers supported frames or even tables.  The prevailing web scripting technology at the time was CGI and Perl which required alot of patience and time.  However, when I heard of a strange new tool from Microsoft called Visual Interdev 1.0, I was intrigued enough to plunk down some cash for it at CompUSA.

      Unlike today where you can't go to a book store without being inundated by web development books, there were no books on how to use Visual Interdev 1.0 at that time.  Fortunately, the documentation was very good, and soon I learned how to tie a database into with a web site.   After programming it in on my home PC in my spare time for about 3 months, I posted it to the Internet and started off the code database with about 2,000 lines of my own code.   Right away I was amazed and excited by the fact that 50 or so people would come consistently to the site every day.  As word of mouth spread the news about Planet Source Code, it began to grow bigger and bigger.  Today, Planet Source Code has over five million lines of source code and averages a hit every second! 

Planet Source Code Milestones

     Among the many changes and milestones that Planet Source Code has gone through in it's rapid growth have been:

  • Database locking problems from so many users trying to access the site at one time, which forced upgrades from a Microsoft Access database back in 1997 to SQL Server 6.5 in 1998, and SQL Server 7.0 in 1999.
  • Reaching the 100,000 lines of code mark in early 1999.
  • Reaching the 500,000 lines of code mark in February 2000.
  • Receiving so many hits that we had to cancel our band-width restricted account with an external ISP and move the servers in-house in March 2000.
  • Traffic increasing so rapidly that we had to purchase a second T1 in June 2000.

 


 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | SQL Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyright 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.