<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by CharlesTechy on Medium]]></title>
        <description><![CDATA[Stories by CharlesTechy on Medium]]></description>
        <link>https://medium.com/@charlestechy?source=rss-1cbdc9bdc56a------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*u5snLY2_KRLqswOIAP9HaQ@2x.jpeg</url>
            <title>Stories by CharlesTechy on Medium</title>
            <link>https://medium.com/@charlestechy?source=rss-1cbdc9bdc56a------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 20:00:06 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@charlestechy/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[I Wired My Instagram Analyzer Actor Straight Into Slack With An MCP Connector — Here’s What Broke…]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://charlestechy.medium.com/i-wired-my-instagram-analyzer-actor-straight-into-slack-with-an-mcp-connector-heres-what-broke-070ea0e57370?source=rss-1cbdc9bdc56a------2"><img src="https://cdn-images-1.medium.com/max/1432/1*oSDN-O5-rx8HBrll_vG2Ww.jpeg" width="1432"></a></p><p class="medium-feed-snippet">I run Instagram Influencer Deep Analyzer, an Apify Actor that scrapes an Instagram profile, calculates engagement rate, and scores the&#x2026;</p><p class="medium-feed-link"><a href="https://charlestechy.medium.com/i-wired-my-instagram-analyzer-actor-straight-into-slack-with-an-mcp-connector-heres-what-broke-070ea0e57370?source=rss-1cbdc9bdc56a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://charlestechy.medium.com/i-wired-my-instagram-analyzer-actor-straight-into-slack-with-an-mcp-connector-heres-what-broke-070ea0e57370?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/070ea0e57370</guid>
            <category><![CDATA[mcp-server]]></category>
            <category><![CDATA[ai-agent]]></category>
            <category><![CDATA[apify]]></category>
            <category><![CDATA[ai]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Tue, 01 Sep 2026 13:09:26 GMT</pubDate>
            <atom:updated>2026-09-01T13:09:26.267Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[How to Process an Image Using ChatGPT]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">To create an image processing system using ChatGPT, you can use a combination of libraries like OpenCV and Python&#x2019;s PIL (Pillow) to handle&#x2026;</p><p class="medium-feed-link"><a href="https://charlestechy.medium.com/how-to-process-an-image-using-chatgpt-a6a115a7362a?source=rss-1cbdc9bdc56a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://charlestechy.medium.com/how-to-process-an-image-using-chatgpt-a6a115a7362a?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/a6a115a7362a</guid>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Mon, 11 Mar 2024 17:12:32 GMT</pubDate>
            <atom:updated>2024-03-11T17:17:14.459Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Integrating React Native with Firebase: A comprehensive guide]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Firebase is a backend service platform that provides a set of tools and services to build mobile and web applications. It offers a variety&#x2026;</p><p class="medium-feed-link"><a href="https://charlestechy.medium.com/integrating-react-native-with-firebase-a-comprehensive-guide-268a255f670a?source=rss-1cbdc9bdc56a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://charlestechy.medium.com/integrating-react-native-with-firebase-a-comprehensive-guide-268a255f670a?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/268a255f670a</guid>
            <category><![CDATA[firebase]]></category>
            <category><![CDATA[react]]></category>
            <category><![CDATA[backend]]></category>
            <category><![CDATA[react-native]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Wed, 10 May 2023 03:40:41 GMT</pubDate>
            <atom:updated>2024-03-11T17:19:06.521Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Design Patterns: Best Practices for Writing Maintainable and Scalable Code]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Design patterns are a set of proven solutions to recurring problems in software design.</p><p class="medium-feed-link"><a href="https://charlestechy.medium.com/design-patterns-best-practices-for-writing-maintainable-and-scalable-code-1be6dd5d5861?source=rss-1cbdc9bdc56a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://charlestechy.medium.com/design-patterns-best-practices-for-writing-maintainable-and-scalable-code-1be6dd5d5861?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/1be6dd5d5861</guid>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[developer]]></category>
            <category><![CDATA[best-practices]]></category>
            <category><![CDATA[advice]]></category>
            <category><![CDATA[code]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Wed, 10 May 2023 02:59:09 GMT</pubDate>
            <atom:updated>2024-03-11T17:18:39.588Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[How i got my first Apple laptop as a developer]]></title>
            <link>https://charlestechy.medium.com/how-i-got-my-first-apple-laptop-as-a-developer-bd3bab60f591?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/bd3bab60f591</guid>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[scholarships-for-students]]></category>
            <category><![CDATA[blockchain-technology]]></category>
            <category><![CDATA[developer-stories]]></category>
            <category><![CDATA[storytelling]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Sun, 16 Oct 2022 16:18:14 GMT</pubDate>
            <atom:updated>2022-10-16T16:18:14.753Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Sedenu Charles &amp; Ekeremor Doubra" src="https://cdn-images-1.medium.com/max/681/1*UUQ1NK-eECwD3hfsGThnhw.jpeg" /><figcaption>Sedenu Charles &amp; Ekeremor Doubra</figcaption></figure><h3>The introduction</h3><p>It happened in the middle of the year, 2019 when I got a call from my friend Doubra, explaining to me with excitement about the interest of an organization in designing and developing a website for its activities. After several discussions with my friend, He gave my contact to his boss at the time known as ‘madam Rita’ (Head of media unit) Christ Mercy Land “Aka” Arena of solution and power. She reached out to me and we had a negotiation on the price she was to pay for the job. We negotiated and came to an agreement and I was satisfied with the negitiation.</p><h3>About the Organization</h3><p>The organization, a church to be precise is identified by the acronym “GSM” Global success Ministries and was founded by Dr. Chima Okeke, one of the popular and influential pastor around the world. One faithful day after returning from school, I got a call from the General overseer of the church, Dr. Chima Okeke requesting how long it would take to get the job done with his specifications. Two days later , I got a WhatsApp message from my friend after all efforts trying to reach him for a while failed.</p><h3>The Good News</h3><p>The message read: ‘Prepare we are going to Lagos to meet with the founder of Global Success Ministries at his residence at Festac in Lagos, Nigeria. That was the third or fourth professional work I would work on outside my location, I discussed it with my brother, who later informed my Mum that I would be going to Lagos. I got messages from my Aunt and Mum that I should be careful and I prayed. Being a determined young boy, I took the risk and left for lagos. We got to Lagos very late that night due to heavy traffic on the streets of Lagos. How crowdy Lagos is! We then entered one estate at Festac Amuwo-Odofin.</p><h3>On Arrival at Festac, Lagos, Nigeria</h3><p>We got to the church and we were both welcomed warmly by the Pastor and then taken to the hotel reserved for us. i and my friend took a quick shower and rested well. In the morning, we went back to the church to have a conversation with the man of God, Dr. Chima Okeke. After the discussion, he asked us to conclude with the media head who happened to be a graphics designer, Pastor Gideon. We were able to seal the deal and . analysed the time the project would be concluded</p><h3>The Conclusion</h3><p>We returned to Delta State the next day, since our final exam was around the corner. So, I had to upgrade my laptop at the time which I fondly called ‘my sweet HP 250’, that I collected from my cousin with half payment. After receiving the payment from GSM, I was able to pay him off. I got an Apple l;aptop for myself, paid in full and clean. That was how I was able to purchase my first ever apple laptop (Mac-book pro).</p><p>The main story of the Apple system may be published on storyteller someday. You need to have a friend like Doubra GOD bless you big time bro.</p><p><a href="https://storyteller.ng/">Read more stories on Storyteller</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bd3bab60f591" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Restored Broken Piece — Story Teller]]></title>
            <link>https://charlestechy.medium.com/the-restored-broken-piece-story-teller-5a8d76a1a8f5?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/5a8d76a1a8f5</guid>
            <category><![CDATA[pain]]></category>
            <category><![CDATA[sexual-abuse]]></category>
            <category><![CDATA[jesus]]></category>
            <category><![CDATA[broken]]></category>
            <category><![CDATA[sex]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Wed, 27 Apr 2022 11:44:13 GMT</pubDate>
            <atom:updated>2022-10-16T16:21:10.441Z</atom:updated>
            <content:encoded><![CDATA[<h3>The Restored Broken Piece — Story Teller</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*A_6MWqg1_BtHRdsw.jpeg" /></figure><p>The Restored Broken Piece</p><p>Hi my name is <strong>Bolaji Folarin</strong>, am here to share my story with Storyteller today;</p><p>Since I was a kid I have this spirit of bitterness, anger and spirit of keeping things to heart, while in Junior Secondary School (JSS3), I was manhandled by my uncle’s last wife, who happened to be close to my mother while she was still alive. Whenever my uncle is not at home, being an orphan, that was the worst experience ever from someone I called my mother. Most times she threatened to kill me or ask my uncle to send me away.</p><p>After my JSS3 examinations, I planned on travelling to Jigawa to see my mother’s immediate older sister, of which I related with my uncle and he agreed and even said I could go. In other to experience another city before coming back for my Senior Secondary School.</p><p>A week before I was planning to travel, my uncle called me to let me know that my travelling had been cancelled as he had called my aunt, who happened to be in Jigawa and she told him there would be no need for my coming; little did I know that my uncle didn’t call my aunt rather it was the mischievous plan of the wife so she could continue the evil acts she had been doing to me.</p><p>That night on the 5th day of August 2013, after my uncle had gone to work, he was on night shift that day. When the children were all asleep, she came to my room, Oh! I forgot to add, I had my personal room which she instigated, so I could stay alone since I was older than their kids. She asked me what I told my uncle, and I replied — “nothing” she was furious and angry with me; when she was calm, she gave me reasons why I couldn’t leave.</p><p><strong>Bo, </strong>you can’t leave now as you have a lot of things to do for me so she said, I asked a question fidgeting, things like what ma’am? That I can’t go to my aunt’s place for holiday?</p><p>You know <strong>Bo, </strong>you’re such a young, vibrant and a very fine boy and you know you are always at home and available to help me around with so many things. So, you can’t just leave that way. I was wondering if I hadn’t done enough in the house already until she started touching me in kind of way and asked me to leave without saying a word to anyone.</p><p>So, my uncle didn’t allow me to travel due to the wife’s advice; not knowing the reason why she refused my travelling. Due to the fear of be punished by this woman, I was unable to speak or share this incident(trauma) with anyone not even my best friend ( <strong>Tobi Akorede</strong>).</p><p>Now, I’m in Senior Secondary School (SS1) first term to be précised. On the 19th day of resumption, a preacher was invited to our school fellowship which takes place every Friday.</p><p>Passing through my GOD forsaken bondage, I refuse to attend the fellowship, though my friends invite me often but then I promised to come and never showed up. But on the 11th day of June 2014, I decided to follow them to the fellowship. The theme for the fellowship that day was “JESUS STILL FIXES THE MISSING PIECE”.</p><p>At the fellowship ground that day, I felt something strange came over me pressuring me to go out when the altar call was made. He added “JESUS WON’T FIX IT, IF YOU DON’T ALLOW HIM”. So being pushed by a strange force, I went out for the altar call to surrender to JESUS by giving Him my all.</p><p>So, after the program that day, I went to see the pastor as he asked me to see him after the benediction (closing prayer). On seeing him it was like me seeing an angel, and I shared my story with him, he started asking about my parents, my siblings, I started crying on sharing my mother’s death with him.</p><p>To be Continued.</p><p><em>Originally published at https://</em><a href="https://storyteller.ng/story/the-restored-broken"><em>storyteller</em></a><em>.ng.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5a8d76a1a8f5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My journey into tech part 1: The grandma’s impact — Story Teller]]></title>
            <link>https://charlestechy.medium.com/my-journey-into-tech-part-1-the-grandmas-impact-story-teller-e28ade46f719?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/e28ade46f719</guid>
            <category><![CDATA[twitter]]></category>
            <category><![CDATA[programmer]]></category>
            <category><![CDATA[developer]]></category>
            <category><![CDATA[storytelling]]></category>
            <category><![CDATA[storyofmylife]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Wed, 27 Apr 2022 11:41:33 GMT</pubDate>
            <atom:updated>2024-10-18T11:19:50.448Z</atom:updated>
            <content:encoded><![CDATA[<h3>My journey into tech part 1: The grandma’s impact</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*-td9AYWYo1WpF4Hc.jpeg" /></figure><p>My journey into tech part 1: The grandma’s impact</p><p>Hey! I am happy to share my story with you all today; most of my teenage days were spent with my grandma who happens to be the oldest daughter of their family.</p><p>My journey into the tech space today won’t be complete without making reference to my grandma late <strong>Mrs. Medina Ekhaizor</strong> — A woman with a heart of gold, GOD fearing and an amazing grandmother.</p><p>It was late 2011 August to be precise; when some persons from Living Faith Church Alias Winners Chapel came to my school; Success Secondary School, to talk about free computer literacy, which was not really free. After closing from school that day, on getting home I and my cousin Julie told my grandma about the advert and what one can do with computer after learning; after explaining much about the advert to her she enquired about the price of which we told her it was a thousand Naira, she then asked us to start that July 31st since the training was schedule to last for 6weeks.</p><p>So, we started the training, sometimes we enter an Okada. Otherwise, we trek to the Living Faith Church which is almost an hour away from home, and also do the same thing after closing, but on a Wednesday, we were asked to stay for their mid-week service, which I always like to attend.</p><p>Classes for training start from 8:00am through 4:00pm everyday but I was unable to attend the full weeks since we do go to church on Sundays and not all Saturdays were suitable but we just have to attend for knowledge’s sake. It seems my grandma knew she would be leaving me in no time and decided to do all this.</p><p>On a Friday which is normally our day for test, each group were to choose a representative to represent them at the test since learners where much; we were about 5 groups of which I was in group D if I can recall correctly, some of the persons I can remember being on same group are as followed: Freeborn, Abiola, Uche, Darlington who happened to be the girl who told me I can’t represent our team(group), although she was a bit older than me and later my team mates choose me to represent them. I went there and I did the job, I thought my team failed but I heard someone clapping from behind; on checking who the person was, it was the church then resident pastor; Pastor Kelechi.</p><p>Pastor Kelechi said to me you are brilliant and how did you do that? but I was not able to explain how I solved the problem on Microsoft Excel even till date, I don’t know how I was able to fix(solve) that problem.</p><p>So, from 2011 to 2013 there was no laptop or desktop to exercises all my trainings, so one faithful day, I was able to link to my auntie in the United States of America via Facebook one of the popular social media site today, on reaching her, I told her about my desire to own a personal computer (PC). but took some time to respond but she did finally respond. She informed me that she just sends 100box to me ($100) which was about NGN35,000 then, so I had to travel from home to Auchi which is a different local government from my local government without the notice of my uncle (grandma’s brother) who i was staying with at the moment, on getting to the bank at Auchi I was asked for some credentials of which i tried presenting my voters card which was rejected.</p><p>And the pin from western union which was sent to me by my auntie ( <strong>Evelyn Omo-Abu</strong>). the bank guy asked me not to expose it like that as it can be compromised and my funds would get extracted. So, I immediately hid the pin knowing fully well that without that I won’t be able to buy the laptop I needed.</p><p>So, after the bank rejected the credentials I presented, it was now time to return to my local government area (Agenebode) but I was out of funds that moment and I was tasty; after much trekking from the bank’s site. I went to visit a friend asking for help so I can return back home; so I can be in school tomorrow but all gave me the same reply, so I took courage and my faith was made alive that moment. and I trekked to the motor (car park) and I was just wandering up and down just trying to get any driver’s attention but none answered me. It looks more like all hope was lost and my faith was about fidgeting, I had to give one last try, I then asked a man (a driver) though have forgotten his name, I explained my situation at the moment to the man. The man was GOD sent that day.</p><p>I got home to my local government that day at about 7:00pm, so the next day or that night I told my auntie my experience. So, I was able to find a way to withdraw the money.</p><p>After the withdrawal I was able to buy a laptop at NGN18,000 from a book vendor who put his laptop up for sale. The laptop has the following description Dell inspiron, 8gb Hdd, 1gb ram, running on window Xp, very small computer, battery doesn’t last up to an hour. So, I was happy using the laptop to do things I planned on doing but I was not satisfied and comfortable as the laptop gets drain easily and the space was hell. So, I had to buy a USB card reader and I bought 8gb memory card so I can plug the card reader in anytime I want to use the software on my memory card and the system was now okay for me as I have a memory card I can insert anytime. Still in secondary school, there is this my classmate who happens to be a phone repair guy, he has two laptops one Hewllet Packard (HP) and one Dell (without battery) it only comes up when plugged to electricity else it can’t be used, and when there is power failure or outage the system goes off immediately. I lost a lot of files due to this so I implore <strong>Control + S</strong> as my best friend to save quickly without losing files and contents as before.</p><p>This my story I hope it inspired you? do not worry this is not the end of my journey to be continued later in my subsequent writings</p><p>Thanks for reading my story, kindly share with friends and families</p><p>GOD bless you.</p><p><em>Originally published at </em><a href="https://storyteller.ng/full-story/my-journey-into-tech-part-1-the-grandma-impact"><em>https://storyteller.ng</em></a><em>.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e28ade46f719" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to perform CRUD operations with MySQL using Arctype your favourite SQL client]]></title>
            <link>https://charlestechy.medium.com/how-to-perform-crud-operations-with-mysql-using-arctype-your-favourite-sql-client-c666037ac274?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/c666037ac274</guid>
            <category><![CDATA[database]]></category>
            <category><![CDATA[nft]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[analysis]]></category>
            <category><![CDATA[crud]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Sat, 15 Jan 2022 19:56:45 GMT</pubDate>
            <atom:updated>2022-01-15T19:56:45.112Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>How to perform CRUD operations with MySQL using Arctype your favourite SQL client</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Z6XHhW3WyjEYBtPz5WXk_w.png" /><figcaption>Arctype more than SQL Editor</figcaption></figure><p><strong>Introduction</strong></p><p>Arctype is the fast and easy-to-use database client for writing queries, building dashboards, and sharing data with your team, it supports not only MySQL; it also supports Postgres and PlanetScale.</p><p>MySQL Database Service is a fully managed database service to deploy cloud-native applications.</p><p>MySQL gives developers the privilege of interacting with databases, in this article we are going to be considering the widely used operations regarding databases.</p><p><strong>Explaining CRUD Operations</strong></p><p>Organizations that keep track of customer data, accounts, payment information, health data, and other records require data storage hardware and applications that provide persistent storage. This data is typically organized into a database, which is simply an organized collection of data that may be viewed electronically.</p><p>There are many types of databases: hierarchical databases, graph databases, and object-oriented databases to name a few. The most commonly implemented type of database is a <em>relational database</em>, which consists of data tabled in rows and columns and connected to other tables with complementary information by a system of keywords that includes <em>primary keys and</em> <em>foreign keys</em>.</p><p><strong>Why is CRUD so popular?</strong></p><p>CRUD is constantly used for anything related to database and database design. Software developers can’t get anything done without CRUD operations. Website development, for example, uses REST (Representational State Transfer), which is a superset of CRUD used for HTTP resources.</p><p>On the other hand, CRUD is just as important for you as the <strong>end-users</strong>. Without it, things like registering and logging for websites, creating blogs, subscribing to<a href="https://arctype.com/"> Arctype</a> or bookmarks would be impossible. Most applications we use let us add or create new entries, search for existing ones, make changes to them or discard them.</p><p><strong>Some of the benefits CRUD offers includes:</strong></p><ul><li>It facilitates security control by satisfying the various access requirements</li><li>It simplifies and facilitates application design making it more scalable</li><li>It has better performance compared to ad-hoc SQL statements</li></ul><p>The<a href="https://en.wikipedia.org/wiki/Create,_read,_update_and_delete"> <strong>CRUD</strong></a><em> </em>acronym identifies all of the major functions that are inherent to <em>relational databases</em> and the applications used to manage them, which include MySQL, Postgre, PlanetScale, Oracle Database, Microsoft SQL Server, etc.</p><p><strong>CREATE</strong></p><p>Create allows us to add new rows to tables or create new tables. We can do that using the command, <strong>INSERT INTO.</strong> The command starts with the <strong>INSERT INTO</strong> keyword <strong>CREATE TABLE,</strong> followed by the table name, column names, and the values to be inserted.</p><p>When using <strong>INSERT INTO</strong>, you have two options:</p><pre><strong>INSERT INTO tbl_name VALUES (value1, value2, value3, …);</strong></pre><p>or</p><pre><strong>INSERT INTO tbl_name (column1, column2, column3, …)</strong></pre><pre><strong>VALUES (value1, value2, value3, …);</strong></pre><p>And when using CREATE TABLE, you use this:</p><pre><strong>CREATE TABLE tbl_name (col_name col_type constraints);</strong></pre><p>Note:</p><p>If you have knowledge of Arctype before skip the link before else try reading the content before proceeding with this tutorial</p><p><a href="https://docs.arctype.com/getting-started/connecting-to-a-database">How to establish a connection using Arctype your favorite SQL client</a></p><p><a href="https://docs.arctype.com/getting-started/making-a-query">You may want to read about creating and running a Query with Arctype</a></p><pre><strong>use blog;</strong></pre><pre><strong>CREATE TABLE articles (title Varchar(100) NOT NULL, commentCount Integer);</strong></pre><p>The Created Table Output</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/978/1*euq1SsmaDD6Kyp2oj3EUqg.png" /></figure><p><strong>READ</strong></p><p>The read function is similar to a <em>search function</em>, as it allows you to retrieve specific records and read their values. Read refers to as <strong>SELECT</strong></p><p>For instance, let’s take a look at the articles we have at our blog. To do that, we have to display all the data in our menu table using:</p><pre><strong>use blog;</strong></pre><pre><strong>SELECT * FROM articles;</strong></pre><p>The above Query will select or read(display) all the data from the database without making any changes to the data present on the database.</p><p><strong>READ OPERATION OUTPUT</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LUQZ4RyMeN90M__1O-1zDQ.png" /></figure><p><strong>UPDATE</strong></p><p>Update is how we change an existing record in the table. We can use this to modify existing records that exist in the database. When performing <strong>UPDATE</strong>, you need to define the target table and columns to be updated. You also need the associated values and sometimes the rows.</p><p>Two commands are widely used for Update data in the database –</p><p>Alter Table Command is also referred to as the DDL command (Data Definition Language) used to change the structure of the table while the Update Table Command is also referred to as the DML command (Data Manipulating Language) used to alter the records.</p><p>To update an existing record in our database, use the following:</p><p>Let’s say we want to update the article title and commentCount. We would use:</p><p>This will update the table so that the previous record whose <strong>id is 12</strong> will now be replaced with ‘daddy is good’ with <strong>400 commentCount.</strong></p><p><strong>DELETE</strong></p><p>Delete is used to <strong>remove a record</strong> from the table. SQL has a built-in delete function for deleting one or more records from the database at a time. Some relational database applications may permit a hard delete (permanent delete) or soft delete (update row status).</p><p>The delete command is as follows:</p><pre><strong>DELETE FROM tbl_name WHERE condition;</strong></pre><p>If we want to remove one article from our blog, we use:</p><pre><strong>DELETE FROM articles WHERE id = 12;</strong></pre><p>This will remove the row with the article with id number 12 from the table. If you want to delete all the records from the table, you can use:</p><pre><strong>DELETE FROM articles;</strong></pre><p><strong>Conclusion</strong></p><p>With Arctype SQL client you can easily manage all your databases with a click just by logging with your database credentials.</p><p>Try downloading <a href="https://arctype.com/">arctype</a> today and make your development faster</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c666037ac274" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to develop an HTML and JS source code viewer using PHP]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://charlestechy.medium.com/how-to-develop-an-html-and-js-source-code-viewer-using-php-8c4c5953343d?source=rss-1cbdc9bdc56a------2"><img src="https://cdn-images-1.medium.com/max/1600/1*J-ie03yZS4ts7q4ecyX1fg.jpeg" width="1600"></a></p><p class="medium-feed-snippet">What is a source code?</p><p class="medium-feed-link"><a href="https://charlestechy.medium.com/how-to-develop-an-html-and-js-source-code-viewer-using-php-8c4c5953343d?source=rss-1cbdc9bdc56a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://charlestechy.medium.com/how-to-develop-an-html-and-js-source-code-viewer-using-php-8c4c5953343d?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/8c4c5953343d</guid>
            <category><![CDATA[source-code]]></category>
            <category><![CDATA[2022]]></category>
            <category><![CDATA[php]]></category>
            <category><![CDATA[html5]]></category>
            <category><![CDATA[bootstrap]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Thu, 06 Jan 2022 20:02:14 GMT</pubDate>
            <atom:updated>2022-04-16T20:22:58.157Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[How to execute PHP cron job on the new Da-manager control panel(Cpanel)]]></title>
            <link>https://charlestechy.medium.com/how-to-execute-a-php-cron-job-on-the-new-da-manager-control-panel-cpanel-634c7f094b77?source=rss-1cbdc9bdc56a------2</link>
            <guid isPermaLink="false">https://medium.com/p/634c7f094b77</guid>
            <category><![CDATA[control-panel]]></category>
            <category><![CDATA[php]]></category>
            <category><![CDATA[da-manager]]></category>
            <category><![CDATA[namecheap]]></category>
            <category><![CDATA[web-panel]]></category>
            <dc:creator><![CDATA[CharlesTechy]]></dc:creator>
            <pubDate>Wed, 05 Jan 2022 21:33:26 GMT</pubDate>
            <atom:updated>2022-01-05T22:08:03.763Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kWo7Xl8me9daCZxx_d2sDA.png" /></figure><h3>What is Cron Job?</h3><p>According to <strong>Hivelocity</strong></p><p>A <strong>cron job</strong> is a Linux command used for scheduling tasks to be executed sometime in the future. This is normally used to schedule a job that is executed periodically — for example, to send out a notice every morning. Some scripts, such as Drupal and WHMCS may require you to set up cron jobs to perform certain functions.</p><h3>Hmm Da-manager?</h3><p>Oh yeah Da-manager!</p><p><a href="https://my.da-manager.com/aff.php?aff=37"><strong>Da-manager</strong></a> is Nigeria’s Best Web Hosting Company offers fast, secure &amp; reliable web hosting, domains, with UK 24/7 Support, Free SSL, Emails and more!</p><p>With quick response and feedbacks <a href="https://my.da-manager.com/aff.php?aff=37">Da-manager</a> has proven to be the best hosting company not only in Nigeria.. you can <a href="https://my.da-manager.com/aff.php?aff=37">register</a> with them today</p><h3>How to Schedule a task?</h3><p>To run or execute your task(script) you will need to login to your da-manager control panel(Cpanel) either with their oneClick user login from your user dashboard or accessing the following address which leads straight to the <a href="https://my.da-manager.com/aff.php?aff=37">Da-manager</a> control panel as seen on the image below</p><blockquote><a href="https://srv5.myukserver.com:2087/login">https://srv5.myukserver.com:2083</a></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZGWEAVC-RapkYz3Yu6WZJA.png" /></figure><p>Kindly fill in your Cpanel (control panel) details correctly and you can select or choose your preferred language or allow the system to decide and click on the login button.</p><p>Entered the right and correct details? you should see a screen like the one below now… can either be in light or dark mode depending on your preference</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jY5HRGFog_CMd6IrxjTMnw.png" /></figure><p>Kindly scroll down and click on <strong>Crontab</strong> under Control Web Panel(CWP) on the image below and you will be redirected to a page to configure your cron settings.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*92o6yo-WBmb0SsT1HS0thQ.png" /></figure><p>Click on <strong>+ Add new cron job</strong> and enter your task configurations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gkHHdOcnq7draoZNhveLEg.png" /></figure><p>At <a href="http://da-manager.com/">Da-manager</a> you can specify your PHP location followed by your script location; for example executing a php script that will welcome every new user.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vvw02INO-EdY-nlXKsj8og.png" /></figure><p>you should consider the following parameters:</p><ol><li><strong>Command:</strong></li></ol><p>This is a box where you input your script location</p><p>e.g <strong>System</strong> <strong>Default PHP</strong></p><blockquote>php -q /home/user_name/public_html/welcome_new_users.php</blockquote><blockquote>php -q /home/user_name/htdocs/welcome_new_users.php</blockquote><p><strong>Specifying your PHP version</strong></p><blockquote>/usr/local/bin/php -q /home/user_name/public_html/welcome_new_users.php</blockquote><p>2. <strong>Description:</strong></p><p>This act like a comment; letting you know what the cronjob is meant to do</p><p>3. <strong>TIME(When to run):</strong></p><p>Time here is all about when your task should run automatically</p><p>for instance we want our tasks to run every <strong>5minutes or 10mins</strong></p><blockquote>we would do this in advance settings<br>*/5****</blockquote><p><strong>Mins: */5</strong></p><p><strong>Hours: *</strong></p><p><strong>Days: *</strong></p><p><strong>Months: *</strong></p><p><strong>Weekdays: *</strong></p><p><strong>Need better understanding about CronTabs?</strong></p><p>you can read more about cron tabs timing and different examples by following the link below</p><p><a href="https://crontab.guru/examples.html"><strong>Check this Crontabs Examples</strong></a></p><p>Check the image below to have better understanding</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bLzPiSqVbnQwLI41kKxBBA.png" /></figure><p>Click on the <strong>Save cron</strong> button</p><p>Congratulation mate you just succeeded in creating your first cron job</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=634c7f094b77" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>