<?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 Vijay N on Medium]]></title>
        <description><![CDATA[Stories by Vijay N on Medium]]></description>
        <link>https://medium.com/@vijay_n?source=rss-968cf34ef289------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*gOuHrM6-6rokfTn7V_uqGg.jpeg</url>
            <title>Stories by Vijay N on Medium</title>
            <link>https://medium.com/@vijay_n?source=rss-968cf34ef289------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 13:23:49 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@vijay_n/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[Evolution of Retail — Till ONDC]]></title>
            <link>https://medium.com/@vijay_n/evolution-of-retail-till-ondc-f736d2064118?source=rss-968cf34ef289------2</link>
            <guid isPermaLink="false">https://medium.com/p/f736d2064118</guid>
            <category><![CDATA[d2c]]></category>
            <category><![CDATA[ondc]]></category>
            <category><![CDATA[retail]]></category>
            <dc:creator><![CDATA[Vijay N]]></dc:creator>
            <pubDate>Fri, 16 Dec 2022 05:11:52 GMT</pubDate>
            <atom:updated>2022-12-16T05:13:22.745Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Evolution of Retail — Till ONDC</strong></h3><p>Retail was always a property game, it was about finding the area where potential footfalls happen and it was a race to acquire the most prominent area. Under the hood, the businesses spend loads of money &amp; time on analyzing the demography and sets up the infrastructure at the right place to enable commerce and yield the max.</p><p>So ultimately the success formula was “<strong>LOCATION</strong>”.</p><p><strong>Location as a key</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TpnPOoGW0TC3Qd8n7lfkTQ.jpeg" /></figure><p>This investment heavy model was disrupted by Internet - the shrapnel from internet explosion has clearly damaged the traditional model and it paved the way for e-commerce platforms to rise, wherein they bypass the traditional brick &amp; mortar.</p><p>This in turn changed the success formula to “<strong>LOGISTICS</strong>”.</p><p><strong>Logistics another Mantra</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RWMck1kiAbv2t7HfOIN21g.jpeg" /></figure><p>It didn’t stop there &amp; it continued to evolve. Thee advent of platforms like Shopify, Woo-Commerce &amp; Wix acted as a catalyst to that evolution where these platforms enable brands &amp; small businesses to bypass the e-commerce platforms and retailers there by establishing a direct channel with the consumers.</p><p><strong>Direct to Consumer — Mantra</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*da804JVjefjN1rW7jfWQ0g.jpeg" /></figure><p>Just like every hot niche, Investors poured money like anything into DTC companies and floated many firms at puffed up valuations(Bn$$). Eventually this model also started showing flaws because of rising Facebook Ad prices, soaring shipping cost and weakening consumer demands, supply chain issues, rising shipping costs. This again resulted in major D2C players show revenue contraction, shrinking margins and runway losses.</p><p>As a nail in the coffin, Apple also played its part by bringing stringent privacy updates to its iOS 14, allowing customers to stop being tracked by these players. This resulted in D2C firms having a blurry view on the ad targeting.</p><p>In short the DTC formula also started showing challenges.</p><h3><strong>Summarizing the challenges &amp; opportunities</strong></h3><ul><li>Platforms are the operators, they define the rules of the game whereas seller and buyer are just subscribers of the integrated solutions provided by the platform. In short, my game my rules.</li><li>These platforms have limited the competitiveness. The new sellers are coming online and just becomes a part of the vast platform.</li><li>Limited Platforms — the amount of investments required to establish an end to end solution of logistics, warehousing, payment is pretty huge which resulted in very few platforms in play.</li><li>Another key problem is the lack of interoperability &amp; portability of reputation. The value or reputation a seller creates over a period of time gets lost if he/she wants to migrate to a different platform due to any misalignment with the existing platform.</li><li>Thus the existing platforms are always designed to stay as a store of value.</li></ul><figure><img alt="Platforms as Silos of value" src="https://cdn-images-1.medium.com/max/1010/1*XVhZTn-Q96L9h2xeWNNfBw.png" /><figcaption>Credits to ONDC Strategy Paper</figcaption></figure><ul><li>What if a seller wants to be on multiple platforms ? Each seller will have to comply with the process defined by those platforms and he/she will have to maintain a separate infrastructure which will add to their costs.</li><li>Discovery of the sellers can be another challenge.</li><li>A customer searching for a product or an online inventory, the neighborhood store should also have an insight that somebody is looking for a particular product which can help the seller in tweaking the offers and arrive at the right product placement on the basis of demands.</li></ul><h3><strong>So ONDC.</strong>. <strong>it can be the next big revolution from India</strong></h3><p>As Digital commerce establishes its strong foothold in India and we have seen 16% to 19% growth over a period of an year (2019–2020) ( Covid accelerated growth). India is the 3rd largest online-shopper base globally, with 14+ crore e-retailer shoppers leaving us just behind China &amp; US and this number is expected to grow approximately 25% more by 2030 because of GenZ’s.</p><p><a href="https://ondc.org/"><strong>ONDC</strong></a> is re-imagining the Digital Commerce landscape by shifting it from a monolithic operator driven approach to a facilitator driven interoperable decentralized way where they solve the problem of trust, interoperability , data stewardship, flow of value, and enabling autonomy of buyers &amp; sellers.</p><p>I wish many ecosystem players &amp; enablers come forward and join this ONDC bandwagon. The Government of India is also encouraging such networks (<strong>UPI, Aadhar </strong>are some examples) &amp; <strong>UPI</strong> is a great success<strong>, recently </strong><a href="https://www.npci.org.in/what-we-do/upi/product-overview"><strong>UPI</strong></a> had done a volume of <a href="https://www.npci.org.in/what-we-do/upi/product-statistics">7Mn in Nov22</a>.</p><p>I hope the grant vision of ONDC of enabling 30Mn sellers and 300Mn shoppers on the network may come true soon, and let the new mantra of retail be “<strong>LOCALISATION</strong>”.</p><p>Hoping to come back with more info on how practical ONDC is.</p><p><em>P.S — A collection of information compiled from various sources ( FT.com, ONDC Strategy, NPCI.org)</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f736d2064118" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Hyper Local Kirana Stores - Nervous System of India]]></title>
            <link>https://medium.com/internetmango/hyper-local-kirana-stores-nervous-system-of-india-40b33b3becef?source=rss-968cf34ef289------2</link>
            <guid isPermaLink="false">https://medium.com/p/40b33b3becef</guid>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[hyperlocal]]></category>
            <category><![CDATA[startup]]></category>
            <dc:creator><![CDATA[Vijay N]]></dc:creator>
            <pubDate>Tue, 14 Apr 2020 06:57:14 GMT</pubDate>
            <atom:updated>2020-04-14T06:57:14.213Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*VReHCAe_7mCDrSutFCA1eg.jpeg" /><figcaption>Source ~ Forbes</figcaption></figure><p>As the world is looming in the shadows of COVID-19, the real hero for India is it’s Kirana stores, which lost it shine due to the modern day trade and e-commerce. Kirana stores made a come back as the E-commerce players are fiddling around with broken supply-chain due to the this unexpected pandemic.</p><p>Kirana stores account about 12Million, that means for every 1000 people there are 10 stores through out the country and is the one and only significant last-mile connector to Indian homes and these stores are responsible for 75% of the FMCG products that reaches Indian homes.</p><p>Understanding this opportunity way before few major players are already in the game.</p><ul><li>Reliance — Low cost PoS solutions to 5 million merchants</li><li>Metro Cash &amp; Carry — With the mission to modernize the small retail stores, digitize and track sales</li><li>Walmart-India — Store &amp; PoS modernization to 200–300 Kirana stores in cities with a mission to profile customers</li><li>Phone Pe — Working with 5 million small business with an App to manage their inventory and push digital payments to semi-urban areas</li><li>Bharat Pe — Free payments for small retailers, monetize by offering loans.</li></ul><p>Before this lock down a significant Urban population were relying on E-commerce and large retail players to get their essentials delivered to their doorstop, but this absolute pandemonium has done this paradigm shift of Kirana stores going omni-channel. Already merchants are aware about the new opportunities opening up for them as we have already seen reports of Kirana stores working with Resident Welfare associations of housing societies, some are taking orders on WhatsApp &amp; delivering it.</p><p>What opportunity it is bringing to technology startups and Hyperlocal delivery companies in India ?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/660/1*0O-vk4vxsrBAMvmKPN_jfQ.jpeg" /></figure><ol><li>Connecting the Kirana stores with the consumers/community seamlessly with the help of an app</li><li>Seamless Inventory Digitization and Integration</li><li>Helping the Urban consumers to identify the nearby Kiranas</li><li>Enabling Delivery from these Kirana Stores which hyperlocal companies can play a major role.</li><li>Being a high touch system building a digital ecosystem around this can be beneficial to everyone in the ecosystem from Brands to Distributors and retailers.</li><li>Decision Intelligence systems tailored for the Kirana stores suggesting what to and what not-to-sell.</li><li>Going Multilingual/Vernacular to reach out to scale.</li></ol><p>Being a technology <a href="https://internetmango.com/">company</a> <a href="https://internetmango.com/">We</a> are at the forefront of this activity by helping startups with a mission to digitize and seamless connect Kirana Stores with consumers.</p><p>In a way COVID -19 is enabling the transition of 400 million merchants to digital bandwagon at a much faster rates. Post COVID-19, lets hope for a new digitized India &amp; focus on wealth creation from the grass root level.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=40b33b3becef" width="1" height="1" alt=""><hr><p><a href="https://medium.com/internetmango/hyper-local-kirana-stores-nervous-system-of-india-40b33b3becef">Hyper Local Kirana Stores - Nervous System of India</a> was originally published in <a href="https://medium.com/internetmango">Internet Mango</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Battle of E-commerce, Spree vs Woo !]]></title>
            <link>https://medium.com/internetmango/battle-of-e-commerce-spree-vs-woo-3064b8d5d547?source=rss-968cf34ef289------2</link>
            <guid isPermaLink="false">https://medium.com/p/3064b8d5d547</guid>
            <category><![CDATA[gdpr]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[ecommerce-web-development]]></category>
            <category><![CDATA[ruby-on-rails-development]]></category>
            <dc:creator><![CDATA[Vijay N]]></dc:creator>
            <pubDate>Thu, 20 Feb 2020 11:52:24 GMT</pubDate>
            <atom:updated>2020-02-20T11:52:24.569Z</atom:updated>
            <content:encoded><![CDATA[<h3>Battle of E-commerce, Spree vs Woo !</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*s69q8O40e21lt6BaoXXNHg.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@gramdaman?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Graham Ruttan</a> on <a href="https://unsplash.com/s/photos/battle-of-commerce?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><h3><strong>What is Spree Commerce ?</strong></h3><p>Spree is an open source E-commerce framework built with Ruby on Rails, which helps in bringing your store front live in no time. This platform out of the box comes with the support of an active community, Well documented, supported and maintained plugins , extensions and 3rd party integrations, and its a perfect platform for those who wants to build a scalable &amp; extensible e-commerce business.</p><h3><strong>What is Woo-Commerce?</strong></h3><p>Woo Commerce is an open source E-commerce platform built on top of WordPress. It’s a light weight solution or considered as an extension to WordPress which was primarily built for managing blogs and It comes with its own caveats, though it is backed an active community of enthusiasts and developers around the globe and it can suit a small scale e-commerce business</p><h3>Features and Advantages of Spree-Commerce</h3><ul><li>Spree comes with a default responsive store front which is customizable to any extent.</li><li>Spree store front is de-coupled, We may use any custom framework to build our own store front &amp; brand it to the business needs and deploy, or if you’re focusing on mobile commerce Spree provides necessary API’s for building the same.</li><li>Blazing fast search capabilities — Spree when coupled with elastic search will give a seamless experience to your customers even with a millions of S.K.U’s.</li><li>Product personalizations and recommendation as per the customer behavior, integration with advanced machine learning libraries.</li><li>Spree supports almost all the debit &amp; credit cards, also it enables country specific payment methods as E.M.I or installments.</li><li>Integration with all the latest digital wallets such as Apple Pay and Amazon Pay.</li><li>Spree has omni channel capabilities, whether its retail, wholesale or online Spree is efficient in managing your inventory, sync product catalogs and stock management.</li><li>Spree has internationalization enabled, i.e it presents an opportunity for your business to go global without worrying about the language, tax compliance, currencies and shipment methods. Spree has seamless integration with major shipment enablers like Shipwire, Shipedge and payment integrations such as Stripe, PayPal, Brain-tree.</li><li>Spree helps you to leverage the power of data by enabling easier integrations with analytics, growth marketing tools.</li><li>Spree has analytics feature so that owner can have a view of the sales happening, also have easier integrations with. Analytics tool such as Kiss-metrics /Mix panel.</li><li>80% of the time spent by the e-commerce owners are on product management, order processing, payment processing and issuing refunds, shipment updates for their customers etc. Spree admin dashboard features/enables these functions by default as well as allows various integrations to enable these and makes the life of an E-commerce business owner/manager easier.</li><li>Spree is a secure system, it was built by following the best &amp; standard security practices in the industry and is in compliant with the laws (GDPR).</li></ul><h3><strong>Why should you choose Spree Commerce for your next E-commerce business?</strong></h3><blockquote><em>If the answer to the below </em><strong>“if’s”</strong><em> is positive to you, then you may consider setting up your online store-front using Spree.</em></blockquote><ul><li>If you’re in the business with a vision to provide a world class virtual shopping experience to your customers,</li><li>If you want to scale up, having high availability to millions of users by preserving the rich UI experience.</li><li>If you want to leverage the data, track user sentiments, do sentiment and predictive analytics to serve your customers better.</li><li>If you’re looking to rollout an efficient and seamless multi vendor market place with less turn around time.</li><li>If you’re bothered about the product count capacity.</li><li>If you’re bothered about custom features.</li><li>If you’re bothered about User Experience</li></ul><h3><strong>Listing out few platforms that uses Spree and has significant traffic and traction</strong></h3><ul><li><a href="https://www.urbanladder.com/">Urban Ladder</a> :- Urban ladder is a pioneer in selling furniture&#39;s online and it has a Country Rank in India of 4853 and in the last six months it has a visit of about 568.62K users.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PcrQsNIPQge8bjP93OxNLQ.png" /><figcaption>Source- https://similarweb.com</figcaption></figure><ul><li><a href="https://milanstyle.com/">MilanStyle.com</a> :- Milan Style probably be one among the biggest online player for fashion designer and luxury branded clothes. They migrated to Spree because of the bottle necks they faced by running WordPress And once after migrating to Spree, they could increase their product portfolio &amp; studies suggests that their conversion rates improved by 35% and above and they were able to scale 10x times. Milan Style has about 74.33K visits from Aug-2019 to Jan -2020.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jre87iTQGcrvr6RwwqqIqg.png" /><figcaption>Source- <a href="https://similarweb.com/">https://similarweb.com</a></figcaption></figure><ul><li>GoDaddy:- GoDaddy is using spree commerce as a multi-tenant solution E-commerce for small business. When GoDaddy started offering E-commerce solutions to small business their main criteria for choosing the tech was based on which platform is more Extensible, Modular, Mature, and have a good community support. Thus finally they narrowed down to spree after considering the all the factors and Spree was a perfect fit for Godaddy to start their E-commerce vertical. For them Spree stood out fast, reliable and supported by world class developers.</li></ul><p>And they scaled it to achieve <br>1.Thousands of unique storefronts.<br>2. Up to 1.5M page views per day.<br>3. And an average response time of ~2.5s.<br>4. 99% uptime.</p><h3><strong>Spree Usage Statistics</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0AmfJ4mmrBN5CKgP18TDMw.png" /><figcaption>Source- <a href="https://builtwith.com/">https://builtwith.com</a></figcaption></figure><p>On the basis of traffic volume — 0.02% of the website which has over 1m traffic is being run on Spree , above 0.06% which has 100K+ traffic also runs on Spree. And Spree is one among the popular website which is in the list of Open Source Usage Distribution in Top10K Sites.</p><blockquote>Source :- <a href="https://trends.builtwith.com/shop/open-source/traffic/Top-10k">https://trends.builtwith.com/shop/open-source/traffic/Top-10k</a></blockquote><p>To conclude :- Spree is being adopted by many existing e-commerce giants and if you feel, the scaling of your business relies on introduction of online store fronts, then Spree can be the tech you can vouch on to build a highly customizable, extensive and scalable platform.</p><p>We at <a href="https://internetmango.com/">InternetMango</a> specialize in E-commerce development with <a href="https://spreecommerce.org/">Spree</a>, feel free to reach out for consultation.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3064b8d5d547" width="1" height="1" alt=""><hr><p><a href="https://medium.com/internetmango/battle-of-e-commerce-spree-vs-woo-3064b8d5d547">Battle of E-commerce, Spree vs Woo !</a> was originally published in <a href="https://medium.com/internetmango">Internet Mango</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Fixing MySQL issues on macOS]]></title>
            <link>https://medium.com/internetmango/fixing-mysql-issues-on-macos-77ea1d3ca8bc?source=rss-968cf34ef289------2</link>
            <guid isPermaLink="false">https://medium.com/p/77ea1d3ca8bc</guid>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[homebrew]]></category>
            <category><![CDATA[macos]]></category>
            <category><![CDATA[devops]]></category>
            <dc:creator><![CDATA[Vijay N]]></dc:creator>
            <pubDate>Fri, 27 Dec 2019 07:29:00 GMT</pubDate>
            <atom:updated>2019-12-27T08:01:34.721Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aBSeDR16DlBTj0lETpDeaA.jpeg" /></figure><p>Recently faced some issues with MySQL after a macOS update, though it was running perfectly on the old version.</p><h3>The main issues</h3><p>Though the system-preference pane the MySQL icon says its running but when I checked for</p><pre>ps -ax | grep mysql</pre><p>and it didn’t give any trace saying that MySQL is running.</p><ul><li>Even if we manually stop/start from the preference pane, nothing was really happening, means MySQL was not working for me</li><li>If you’re also going through the same I request to do a fresh installation of MySQL by following the below mentioned Steps.</li></ul><h3>Solution for the Pain</h3><ul><li>Check whether there is any existing MySQL processing running by giving the command</li></ul><pre>ps -ax | grep mysql</pre><ul><li>If found kill it using</li></ul><pre>kill -9 {PID} </pre><p>or using launchctl</p><pre>sudo launchctl unload -w /Library/LaunchDaemon/com.mysql.mysql.plist</pre><ul><li>I suppose you’re familiar with <a href="https://brew.sh/">HomeBrew</a> , if so give the command</li></ul><pre> brew remove mysql</pre><ul><li>Then issue the command</li></ul><pre>brew cleanup</pre><ul><li>Then find for MySQL traces in your system by issuing the command</li></ul><pre>sudo find / | grep -i mysql </pre><p>it will return a long list and use rm command to remove the significant.( Assuming you’ve the knowledge of the system)</p><ul><li>Then delete the files one by one using rm command i.e</li></ul><pre>rm /usr/local/mysql*</pre><pre>sudo rm -rf /usr/local/var/mysql*</pre><pre>sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist</pre><ul><li>Even if you uninstall MySQL using <a href="https://brew.sh/">Homebrew</a>, the preference pane will be there so in-order to remove that issue the below commands.</li></ul><blockquote>Be careful using these commands</blockquote><pre>sudo rm ~/Library/PreferencePanes/My* </pre><pre>sudo rm -rf /Library/Receipts/mysql*</pre><pre>sudo rm -rf /private/var/db/receipts/mysql*</pre><ul><li>The above gonna fix all the existing issues now you need to use brew again, and check whether brew is updated by giving brew update command</li><li>Then you can install the latest MySQL again by brew install mysql and follow the instructions on terminal.</li><li>After that you can start mysql server using any one of the below commands</li></ul><pre>brew services start mysql </pre><pre>mysql.server start</pre><ul><li>Verify it by using the command</li></ul><pre>ps -ax | grep mysql</pre><p><em>Note: here you won’t be getting that icon on the preference pane again but there are workarounds to achieve that as well</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=77ea1d3ca8bc" width="1" height="1" alt=""><hr><p><a href="https://medium.com/internetmango/fixing-mysql-issues-on-macos-77ea1d3ca8bc">Fixing MySQL issues on macOS</a> was originally published in <a href="https://medium.com/internetmango">Internet Mango</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[PostgreSQL Tutorial for Beginners]]></title>
            <link>https://medium.com/internetmango/postgresql-tutorial-for-beginners-82bf54ac5482?source=rss-968cf34ef289------2</link>
            <guid isPermaLink="false">https://medium.com/p/82bf54ac5482</guid>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[software-engineering]]></category>
            <category><![CDATA[ubuntu]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[postgresql]]></category>
            <dc:creator><![CDATA[Vijay N]]></dc:creator>
            <pubDate>Tue, 17 Dec 2019 10:46:34 GMT</pubDate>
            <atom:updated>2019-12-17T10:47:23.995Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*61prZIlzCcSaMEhhlLMBOw.jpeg" /></figure><p>PostgreSQL is an Object-Relational database management system, its also called as Postgres. The adoption of Postgres has been <a href="https://insights.stackoverflow.com/survey/2019#technology-_-databases">improving a lot</a> in the tech community due to it’s various advantages. This guide is to give a basic understanding of “How to work with Postgres”.</p><p><strong>Installation of Postgres on a Debian Machine</strong></p><p>Run the command below.</p><pre>sudo apt-get install postgresql postgresql-contrib</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/941/1*ABdADNQy0REESwuiRXDgVQ.png" /><figcaption>PostgreSQL installation</figcaption></figure><p>On successful installation of PostgreSQL you’ll receive the message like the below on your favorite terminal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/957/1*X84o-9sd-3ABynsc4dDljQ.png" /><figcaption>PostgreSQL installation</figcaption></figure><p><strong>How to Use :-</strong></p><p>If you’re coming from MySQL you might find this quite different, as Postgres works on the concept called roles .On successful installation, Postgres associates its roles with a matching account name on a Linux system.<br>The installation by default created a user account named postgres which is mapped to a default postgres role</p><p><strong>Switching to Postgres Account:-</strong></p><p>By using the below command you can start using the PostgreSQL DB</p><p>sudo -i -u postgres</p><p>This will prompt for you password and now you’ll be logged in a postgres user. Then issue the following command psql , this will help you to get logged into the PostgreSQL command prompt and now you have logged into your postgres server and can start playing out with it.</p><p><em>Postgres server is different from the postgres command line client (psql). You can use postgres server with other clients like web based pgAdmin</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/598/1*kNUtPe4xxJH8svPbf0y--Q.png" /><figcaption>PSQL Command Line</figcaption></figure><p>You can even access the Postgres prompt without changing into postgres account, You may use the below command for achieving it.</p><p>sudo -u postgres psql</p><p>Once you’re in the command prompt you may use this handy tool/command whenever you’re stuck — \? (<em>BackslashQuestionMark</em>) This command gives you the options you can have on a postgres prompt.</p><p><strong>Listing Databases and Roles :-</strong></p><p>Once you login you can view the Databases &amp; Roles by giving the below commands</p><p>\list — This command will list out the databases.</p><p>\du — This command will list out the roles.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/884/1*E9_tX6b86IR6BeqlRX3v0w.png" /><figcaption>Roles &amp; DB Commands</figcaption></figure><p>If you look at the above screenshot, you may notice that there is a role as well as database with the name postgres, ie by default the Postgres expects to have a database associated with a role and have the same names for both Role and Database.</p><p><strong>How to create a new </strong><strong>ROLE ?</strong></p><p>Right now if you give /du you can see there is only role ie postgres .You can create a new role by using the below command from your terminal</p><pre>postgres@kabylake:~$ createuser --interactive</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/674/1*YfDIfml_VMbO-r5J8K7pIg.png" /><figcaption>CREATE ROLE</figcaption></figure><p>Now you can check the ROLE created by logging into psql command prompt and give \du command.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/831/1*XYz2194SxUKx3XMCSh43Fw.png" /><figcaption>LISTING ROLES</figcaption></figure><p><strong>Create a new Database :-</strong></p><p>Make sure you’re switched as a postgres user, if not use the below command sudo -i -u postgres</p><p>Then use this command createdb vijay (eg: Here I used vijay as DB name as I already have a role named vijay)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/717/1*UHl1JHYgxq7diz-GHl8MNg.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=82bf54ac5482" width="1" height="1" alt=""><hr><p><a href="https://medium.com/internetmango/postgresql-tutorial-for-beginners-82bf54ac5482">PostgreSQL Tutorial for Beginners</a> was originally published in <a href="https://medium.com/internetmango">Internet Mango</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[An Entrepreneurial Journey]]></title>
            <link>https://medium.com/@vijay_n/on-feb-14-2016-me-and-my-2-friends-together-registered-our-company-internetmango-3e99456a07d6?source=rss-968cf34ef289------2</link>
            <guid isPermaLink="false">https://medium.com/p/3e99456a07d6</guid>
            <category><![CDATA[business]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[entrepreneurship]]></category>
            <dc:creator><![CDATA[Vijay N]]></dc:creator>
            <pubDate>Fri, 25 Mar 2016 20:21:46 GMT</pubDate>
            <atom:updated>2016-03-25T20:45:14.815Z</atom:updated>
            <content:encoded><![CDATA[<p>On Feb 14 2016 Me and my 2 friends together registered our company <a href="http://www.internetmango.com/">InternetMango</a>. All happened because we got couple of Projects from outside India, and we executed it very much perfectly within time and the both clients where happy. It was really awesome to see money in the bank account for the first time ever in my life.</p><p>But things doesn’t seems to move smoothly, We are really striving, In-fact I feel like am the one whose striving smooth , as 2 of my partners being employed , I personally have to make money for my daily living as well, being said that they are very much co-operative and helping me many ways, financially as well :) Yea you guessed it right I am lucky to have such partners as well , Yea I consider myself lucky in that case .</p><p>The real problem , I been facing as an Entrepreneur living in Kerala and operating here is it’s really hard to get works , the main issue I observed is majority of the business here in Kerala are already been tied up with some existing service providers in IT industry , and the conversion time even if we convince some one is too much. Three main things with which we can convert them from my experience is by</p><ol><li>Offering them a low — quote</li><li>Influencing them politically</li><li>Least one is by convincing them with dialogues</li></ol><p>I mentioned least one that because, from my experience I approached one among the big players in the industry and they where very much convinced by me, and at the last moment ,even after preparing the agreement documents, they waved a red flag, as some one inside their firm wants to go with some particular company. So even if you convince few in a big firm, some or the other is having great contact with some existing players and can turn your offer down.</p><p>I can see in news papers, and other magazines its mentioned startup’s are being funded, heavily! ah I don’t think so. I didn’t receive any single penny. Well since we are currently into service model I actually don’t know whose gonna fund. I really don’t know whom we will approach. Well we are trying many ways to find a way out , to build a sustainable model and scale gradually. There are many startups popping around us and are vanishing in no-time also , I don’t want mine to be like that, we are actually trying to make use of technology and make things simpler , rather than going into core-technology and build an Iron Man initially. Well would love to build an Iron Man once we stand on two-legs.</p><p>Well this journey is really tensing, Well personally I really feel alone, and at some times when you travel, drive you feel like where are you going, and whats gonna happen, and when you hit bed , you can feel your heart pumps , All day-night, all instants your mind is like what I am gonna do, how can I get business. A lot of question marks around me! At times I feel like this startup thing is for those who have money in their DAD’s pocket.Huh for me this is the first and last resort, because I always wished to have something my own. And I am giving it a try. Many many thoughts haunt you daily, some are really frustrating. At times I do feel like, death would’ve been better , but again some or the other , some friends, some other Entrepreneur’s around you giving me some hope to fight, to keep the heads up.</p><p>As of currently we are currently going on with couple of domestic works as well as in talk with few international folks as well, and luckily I got a foreign point of contact, and established a relationship there hoping for some good things to happen. The plan is to generate some revenue, build a dedicated team and to focus on the product idea we have in our mind. Well this is not something new, as I believe as every entrepreneurs might had the same thought. I don’t want to make a mistake here, as everyone say take risk, take risk yes of course I am taking the risk but in a wiser way , I don’t want to jump on the basis of emotion , I am really thinking and I am figuring out the ways to grow and succeed this time, yea I was an utter failure but from last Feb2016 I feel like yea I had taken an important step towards success. Though Am being neglected at many place, in and around family, among some whom I considered friends. Well I consider all these as positive as one of my brother told me, “when you travel heights of course you’ll have to loose some , so be prepared to loose”, yea thats always ringing in my ears.</p><p>I want to win this time, and I think my co-founders a lot for staying with me , Especially @Linjo, you been a great support , a real hardworking and focused human being who believes in practicality rather than getting lost in fantasy , he is the one who is formulating some great plans and yea we together believe we can reach zenith of greatness. We are weaving the patterns to succeed and stand at the top.Well I don’t have degrees in papers, but now as one of my other co-founders said I had experience , I had better experience than Business school student, what they learn in books, I had experienced it in life.</p><p>Ah now I feel little relaxed. Well I started writing this post, as I was feeling completely down and empty . I was not getting sleep, so I dumped my thoughts here. Well haunting thoughts are quite routine these days. Well now am looking forward , searching and identifying problems and solve that. As <a href="http://www.internetmango.com/">InternetMango</a> itself stands for solving one’s pain by using technology. Hope we succeed in solving problems and evolve in a great manner.Hope we break the odds and set another example, have can you evolve from</p><p><strong>“Zero to Infinity”.</strong></p><p>And May the force be with us.</p><p>PS. sorry for the typos ;)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3e99456a07d6" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>