QuickerSite is available on GitHub as from 2020.
You may want to star, fork, follow, download and/or contribute to the project over there. Thank you!
The answer is short: the ADO & ODBC tandem.
ADO is a programming interface to access data in a database. As from IIS 4 (Windows 98, PWS), the ADO programming interface ships with IIS as a built-in interface. ODBC stands for Open Database Connectivity. ODBC is a standard application programming interface (API) for accessing database management systems (DBMS). It's available to any Windows operating system as from Windows 95. (source: Wikipedia)
Long story short: in classic ASP - when using the the IIS-built-in ADObjects - you can connect to any popular DBMS (Oracle, MySQL, SQL Server, PostgreSQL, ...) by simply creating an ODBC connection on your local computer or server.
To use such DSN in your classic ASP application:
dim db : det db = Server.Createobject("ADODB.Connection")
db.Open "DSN=mySQL" (in case you named your ODBC connection "mySQL")
From there on, your can launch any CRUD (Create, Read, Update, Delete) statement against your data. Both MySQL, SQL Server, Oracle and PostgreSQL provide 64bit ODBC drivers. So classic ASP developers benefit from the very latest bug fixes and improvements that come with every new release of any given ODBC driver.
This is amazing. And it somehow ensures that classic ASP is there to stay. Even if it's going nowhere. Perhaps ... because it's going nowhere. I really think so.
For a customer I need to babysit 6 WordPress websites. Shocking results after 1 full year of babysitting:
1 year... This is a joke. QuickerSite hasn't been upgraded since 2014. Not a single issue. Guess to which CMS I will migrate these 6 sites....
Few weeks ago I received this message. It really meant something to me. So I decided to share, as an alternative Happy new year wish. Happy New Year BTW!
"Pieter, many years ago I came across Quickersite and I payed I think for something (I hope I was a payer and not just a downloader) and I was overwhelmed with how amazing it all was. I thought I'd found the holy grail for me being a provider of web services... but my history has followed a similar trajectory to QS and I'm now wandering the plains with a lot of other buffaloes wondering what to do next. I read your posts occasionally as they are, and for a weird reason - it gives me hope. Hope because what you had going here was SO ON THE MARK. But the world rotated a little in another direction and twitter/FB / Instablah and all the other mindless platforms took the collective consciousness away from individual effort and relevant opinion, such that QS no longer had a home. ... Why? Who knows, the world is just different now and windows of opportunity open and close for the most inexplicable of reasons. This could of course be used as an equal answer to: "Why does humanity exist"? A: "For inexplicable reasons". So; no more Concorde, no more digital watches, no more moon landings and no more QS. It is in good company and I loved it."
Hi fellows of QuickerSite,
It took a while again to come up with a new blog post. It sure seems like I’ve doing basically nothing lately. And even if that’s the case for most of the time, I DID come up with some ideas to break the extreme boredom of my life.
For some reason, in the past week, a single of one my songs got released on YouTube, Spotify, Apple Music and Deezer. And it is airplayed on a bunch of local radio stations in both Belgium and The Netherlands. Go figure. And I’m even in it for nothing. I got amazing support from a friend musician, my bass-player actually.
It’s a Dutch song about the huge collection of old, wrong and lost loves of my live. There are a few dozens.
Please be my guest and discover, enjoy and SHARE as much as you can. I love you!
Today I built a website for a customer again… finally. The last site I did dates back from a couple of months ago. It really feels like I’m retiring. But I’m not, nowhere near actually.
I did it in Mobirise - the free edition - even though I have a commercial license. That’s because I want my customers to be able to take over the site after I hand it over.
Some say Mobirise is boring. And that’s true. Especially the free edition is… plain stupid & simple. But it works. Customers DO understand how to drag/drop a block, add an image, edit a text, and next click publish. So they’re happy.
I have 2 accounts at Mobirise. One for my commercial license, the other for the free one. All it takes is 2 different email addresses. Not very complicated in the end. But you also need 2 different computers to handle this. And that’s a little annoying.
It sure looks like Wix is everywhere these days. They must have a very appealing reseller/affiliation program. I personally think Wix is extremely expensive compared to self hosted solutions like WP, Mobirise or QuickerSite.
Talking about QS… It still hurts to realize we didn’t make it. Because QS (still) is the most reliable, the fastest, the most versatile CMS I could ever have come up with. The galleries, the formbuilder, the newsletter, the intranet, the forums, the list pages, … these were all very useful features. And they still are. I recently (few weeks ago) uploaded quite a few improvements to the QS GitHub repository. Mainly cosmetical changes, and things related to HTML5 (finally). Small improvements for all sorts of forms and the QS formbuilder.
But those updates do not change the fact that QS is dead. But not yet buried.
My aspLite experiment ended up nowhere too, and no one seems to understand where this could have lead to, or how it could have put classic ASP back on track. But as MS is focusing more on hosted services (Azure, Office 365, Xbox Live, GitHub and more) it’s becoming clear that guys (or small companies) like me have absolutely no impact on the future of their hosting/developing products. We’re on our own. So they are. It’s sad. Open source technology has taken over this past decade.
I’m near to complete a first release of aspLite. There is still some documentation to write. And that will no doubt result in a few optimizations and fixes.
What started off as a light-weight ASP/VBScript framework (a bit of an empty box though), turned into a very exciting ASP Ajax formbuilder, facilitating feature-rich SPA’s (Single Page Applications).
The new demo is such an SPA, including 24 different forms. Some are expecting user-input, others are just delivering dynamic content.
These past few days I started to realize that developing such SPA’s is much more complex than building web applications the more “classic” way, with plenty of response-redirects to rebuild tables and parts of the GUI. It’s obviously more complex to build Ajax-driven apps. Hence the need for a framework.
Because things can get complicated very quickly, I made sure to include a "basic" example that most ASP/VBScript will quickly be able to understand (including me).
If you did not have the chance to have a closer look at aspLite, make sure to do so and download the current version from GitHub. Please report any bug or share any feedback! I'd love to work towards a first release in the coming days.
It’s not even a month ago that I baptized my early Covid19 ASP-experiments aspLite…. This past month has been amazing. Just to name a few things:
Not bad for just 1 month...
For some weeks now I'm on a crazy development trip. It's really serious. Terrifying. Ever since this Covid crisis I'm basically doing nothing but code my way through numerous ideas and issues. Day by day. From the moment I wake up, I start making to do lists from everything I've been thinking of during the night. I remember I went to the exact same thing when I developed QS, back in 2007-2008. I haven't changed a bit apparently.
And yes, it's all about ASP/VBScript. I am developing a new framework: https://github.com/PieterCooreman/ASP-VBScript-Framework. How stupid is that??? It's incredibly stupid. But I like it so much.
This thing needs a name... Can't think of anything.
My development trip sure has been given an amazing boost by GitHub. GitHub has made me feel comfortable as a developer again. It takes care of versioning, keeps track of the history of scripts, releases, etc. GitHub Desktop helps a lot to synchronize my local development environment with the online repository. I discovered "Markdown" as an easy way to write release notes and documentation. Anyway, GitHub adds a lot of professionalism. And I need that.
GitHub also serves as a basic free CMS: https://pietercooreman.github.io/ASP-VBScript-Framework/.This "projectpage" lists all Markdown (.md) files in a given branch. You can select a template (basic). That page gets automatically updated when I write documentation in my Markdown files. In theory, a GitHub repository can be *just* a bunch of Markdown files - thus a simple website. And it has SSL. See https://pages.github.com/
ALL FOR FREE...
I'm waiting for a contributor to jump-in on any of my repositories. I have 8 of them. So far, nobody has presented him/herself as a contributor. But I understand. I'm on such an intense trip that I would not be able to cooperate with anyone anyhow.
Programming is a very very very lonely business after all. I really think it is. Pretty much like writing songs is. It's me, myself and I. But that does not mean getting input and feedback from others is not important. It usually drives the developer towards even better results.
Weird times. As a father, I love being stuck with the children. As a developer, I love having time on my hands to focus on new technologies and learn new things. As a musician, I love the silence around me. But people are getting infected and are dying at a rapid pace. Very ambiguous.
Bootstrap is still doing very well too. The first version of Bootstrap was released in 2011. That was around the time I stopped the active development of QS. I somehow regret not having adopted Bootstrap for the QS backsite (and some front-end modules). I once added a Bootstrap 3 compatible menu-tag: QS_BOOTSTRAPMENU_3. I guess it still works. But Bootstrap is on version 4 now.
On a side note... Given the popularity of this uncompiled scripting language for both frontend, backend and even mobile app-development, Microsoft could have been much more successful by extending their own (more visual) variant named VBScript, the scripting language that is most often used in ASP classic code. That is... instead of creating their bloated .net monsters. Have I said that before?
Keep it safe out there. Or better... stay inside!
Time has come to realize that QuickerSite has come to an end. Active development stopped somewhere in 2014 already. I will keep on hosting QuickerSites for my customers as well as for some resellers.
This is a tough decision, but it feels like the right thing to do. I have finally made up my mind about offering hosted services only, rather than freely redistribute and support codebases that need updates and patches on a regular basis.
This website QuickerSite.com, the forums and some other functions will be available for many years to come. Existing users can always contact me on firstname.lastname@example.org to receive the latest version of QS or discuss any issue. I will no longer offer the QuickerSite-codebase to new users however as from February 2020.
This has been a wonderful adventure and as is often the case, the most important thing that remains is friendship. Thank y’all for this wonderful time.
© QuickerSite webCMS 2020