Posts

Caspio

Image
Introduction Caspio is a no-code platform designed to help businesses quickly build and deploy custom web applications without writing code. Although it specializes in database-driven application development, organizations requiring highly advanced features or extensive customization may find its capabilities limited. Plans However, Caspio’s existing Free Plan - which offers unlimited users and app usage with up to 50,000 data records - will end on October 1, 2025 . It will be replaced by a $100/month Lite Plan. Users can still trial a fully-featured account for 14 days, but all data will be deleted after the trial period unless the account is upgraded. Keyword Searching Across Multiple Fields To enable keyword searching across multiple fields, you need to create two DataPages; a Submission Form and a Report . The values from the first form will be passed to the second using virtual fields. Submission Form In the Select Fields page, move any available fields into the selected field ...

Website Monetization

Introduction As indie developers or website owners, we often enjoy building and sharing useful tools, resources or information with the world. However, the reality of recurring cloud hosting fees, custom domain costs and the need for sustainable income often clashes with that passion. Moreover, as a project gains traction and traffic increases, so do the associated costs, whether in bandwidth, server load or maintenance. This makes monetizing your website or web application a practical consideration, not only to cover expenses, but also to create a path toward financial sustainability, ideally through passive income. Displaying Advertisements One of the most common and accessible ways to monetize a website is by placing ads through platforms like Google AdSense . With minimal setup and maintenance, ads can start generating passive income based on user interactions, either per click (CPC) or per thousand views (CPM). However, ads can have downsides. They may slow down your site, affect...

Setting Up Google Analytics

Image
Introduction Google Search Console (GSC) provides insights into how your website performs in Google Search. It shows how your site ranks, what keywords are driving traffic, and how users interact with your site in search results. GSC focuses specifically on search performance and includes metrics such as: Impressions, clicks, click-through rate (CTR), and average position in search results Top-performing queries, keywords, and landing pages Index coverage, including which pages are indexed or excluded Core Web Vitals, measuring page experience on both mobile and desktop Mobile usability and technical SEO issues affecting visibility On the other hand, Google Analytics is another free tool that focuses on user behaviour once they land on your site, regardless of how they arrived. Starting 1 July 2024, Google Analytics 4 (GA4) , which is event-based, has fully replaced Universal Analytics, which was session-based. GA4 tells you how many people visit your site, where they come from, whi...

Submitting Website to Search Engines

Image
Introduction Search engines such as Google , Bing and Yahoo , continuously crawl the web to discover new content. In theory, they can find your pages through backlinks alone from other indexed pages, so manual submission is not mandatory. However, manually submitting your website is still highly recommended for several reasons: Peace of mind Submitting your site and providing a sitemap ensures that search engines can properly discover and understand your website’s structure. This helps confirm that your pages are eligible for indexing and visibility in search results. Access to optimization tools By verifying your site in tools like Google Search Console or Bing Webmaster Tools , you unlock access to performance reports, index coverage status, keyword impression data, mobile usability diagnostics and core web vitals. These insights can help you identify issues and optimize your site for better search performance. From personal experience, many blog posts may appear as “discovered” o...

Search Engine Optimization (SEO)

Introduction Building a website or blog is often driven by the hope that many users will discover and engage with your content. While there are no guaranteed rules or paid options that ensure a site will be indexed by search engines, Search Engine Optimization (SEO) is a set of best practices aimed at improving your website’s visibility on search engines like Google and Bing. Effective SEO helps drive organic (non-paid) traffic to your site by making it easier for search engines to understand, rank, and display your content in relevant search results. Technical SEO Although search engines are constantly crawling the web like spiders, they primarily discover new websites by following links from existing ones. These crawlers operate at varying speeds and frequencies, guided by complex algorithms that determine how often a site is revisited and how its content is indexed. Submitting your website to search engines (like via Google Search Console or Bing Webmaster Tools ) is optional bu...

Setting Up Custom Domain

Image
Introduction Over the past few days, I have been seriously considering setting up a custom domain for my current blog to improve its domain rating and optimize search engine performance . Choosing a suitable custom domain has been challenging, especially since rxnote.com is unavailable. After exploring several alternatives, I have decided to go with myrxnote.com . The next step was selecting a domain registrar that is both reliable and cost-effective. I chose Cloudflare Registrar , which differs from traditional registrars like GoDaddy.com or Namecheap.com . Cloudflare offers several valuable features with no markup on domain prices and no additional charges for essential services such as DNS management, WHOIS privacy, and domain locking. NOTE: Another reason behind this decision is the intention to set up subdomains for apps developed using Firebase Studio , allowing better organization and integration of related tools and services under the same domain, such as https://idb.myrxnote...

Drug Formulary App

Image
Introduction Ministry of Health Medicines Formulary (MOHMF) is a valuable resource for healthcare professionals practicing at Malaysia. It provides quick information on indications, dosage, availability and prescribing category. Also, it forms the hospital/clinical drug formulary foundation for all government healthcare facilities at Malaysia. Self-Driven Initiatives Multiple unofficial attempts have been made, first started with My Blue Book by My Pharmacist House (last updated to MOHMF 2016-2) , followed with Blue Book (Updated+Brand Name Search) by Apicel (last updated to MOHMF 2020-2) and Blue Book + CPG Malaysia by Ice Cream App (last updated to MOHMF 2023-2). All of these applications are no longer being updated, and the first two have already been removed from the App Store. These self-driven initiatives are infrequently updated and offer little additional value. Therefore, with the introduction of the official MyFormulary app, they become obsolete. MyFormulary App an...