{"id":7,"date":"2017-11-04T12:48:00","date_gmt":"2017-11-04T12:48:00","guid":{"rendered":"https:\/\/cutekothikhbfe.wordpress.com\/?page_id=7"},"modified":"2024-01-02T02:31:07","modified_gmt":"2024-01-02T02:31:07","slug":"blog-2","status":"publish","type":"page","link":"https:\/\/blinksql.com\/?page_id=7","title":{"rendered":"Blog"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"7\" class=\"elementor elementor-7\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6bfa0d24 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6bfa0d24\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-18205eb9\" data-id=\"18205eb9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-56ff50cd elementor-widget elementor-widget-text-editor\" data-id=\"56ff50cd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.19.0 - 29-01-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h1>Welcome to DB Administration and Development<\/h1>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86f577a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86f577a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fa664d4\" data-id=\"fa664d4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-85af55a elementor-grid-eael-col-3 elementor-grid-tablet-eael-col-2 elementor-grid-mobile-eael-col-1 elementor-widget elementor-widget-eael-post-grid\" data-id=\"85af55a\" data-element_type=\"widget\" data-settings=\"{&quot;eael_post_grid_columns&quot;:&quot;eael-col-3&quot;,&quot;eael_post_grid_columns_tablet&quot;:&quot;eael-col-2&quot;,&quot;eael_post_grid_columns_mobile&quot;:&quot;eael-col-1&quot;}\" data-widget_type=\"eael-post-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div id=\"eael-post-grid-85af55a\" class=\"eael-post-grid-container\">\n            <div class=\"eael-post-grid eael-post-appender eael-post-appender-85af55a eael-post-grid-style-default\" data-layout-mode=\"grid\"><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"758\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-media\"><div class=\"eael-entry-overlay fade-in\"><i class=\"fas fa-long-arrow-alt-right\" aria-hidden=\"true\"><\/i><a href=\"https:\/\/blinksql.com\/?p=758\"><\/a><\/div><div class=\"eael-entry-thumbnail \">\n                <img loading=\"lazy\" width=\"768\" height=\"432\" src=\"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-768x432.png\" class=\"attachment-medium_large size-medium_large wp-image-779\" alt=\"\" decoding=\"async\" srcset=\"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-768x432.png 768w, https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-300x169.png 300w, https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-1024x576.png 1024w, https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-1536x864.png 1536w, https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-2048x1152.png 2048w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/>\n            <\/div>\n        <\/div><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=758\"\n                        title=\"Vi editor in Linux\">Vi editor in Linux<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=758\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 8, 2022\">November 8, 2022<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"270\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-media\"><div class=\"eael-entry-overlay fade-in\"><i class=\"fas fa-long-arrow-alt-right\" aria-hidden=\"true\"><\/i><a href=\"https:\/\/blinksql.com\/?p=270\"><\/a><\/div><div class=\"eael-entry-thumbnail \">\n                \n            <\/div>\n        <\/div><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=270\"\n                        title=\"Install PostgreSQL\">Install PostgreSQL<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>1. yum install postgresql-server postgresql-contrib 2. su postgresql 3. postgresql-setup initdb 4. vi \/var\/lib\/pgsql\/data\/pg_hba.conf 5. Find the lines that look like this near the end...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=270\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"February 7, 2018\">February 7, 2018<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"266\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=266\"\n                        title=\"Monitoring in Postgresql\">Monitoring in Postgresql<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>In normal\u00a0PostgreSQL\u00a0operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a\u00a0VACUUM\u00a0is done. Therefore...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=266\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"February 5, 2018\">February 5, 2018<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"250\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=250\"\n                        title=\"Restore Oracle DB in Linux\">Restore Oracle DB in Linux<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>To restore a database from the default directory\u00a0\/backup\/rman use the cmd cmd: RESTORE DATABASE; Restore Specific Tablespace: Instead of restoring the full database, you can...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=250\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"January 31, 2018\">January 31, 2018<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"248\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=248\"\n                        title=\"Backup Oracle DB using RMAN in linux\">Backup Oracle DB using RMAN in linux<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>1. View Current RMAN Configuration Before we take the backup, we have to configure certain RMAN parameters. For example, how long you want to reatain...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=248\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"January 31, 2018\">January 31, 2018<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"246\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=246\"\n                        title=\"Oracle DBA Roles\">Oracle DBA Roles<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>A database administrator&#8217;s responsibilities can include the following tasks: Installing and upgrading the Oracle Database server and application tools Allocating system storage and planning future...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=246\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"January 31, 2018\">January 31, 2018<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"238\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=238\"\n                        title=\"Orcale DataBase Set up in Windows\">Orcale DataBase Set up in Windows<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>Go to orcale.com Go to downloads as shown in the image and select the compataible version of the system by accepting the license and click...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=238\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"January 30, 2018\">January 30, 2018<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"229\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=229\"\n                        title=\"MongoDB\">MongoDB<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>Features: -&gt;MongoDB is a No SQL database. It is an open-source, cross-platform, document-oriented database written in C++.C-&gt;\u00a0It stores data as documents, so it is known...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=229\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"December 12, 2017\">December 12, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"227\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=227\"\n                        title=\"SQLite\">SQLite<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt; SQLite is an open source, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application. -&gt;\u00a0SQLite does not have...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=227\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"December 10, 2017\">December 10, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"222\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=222\"\n                        title=\"Basic Commands in Mysql\">Basic Commands in Mysql<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt;\u00a0This is the world&#8217;s second most popular and widely used open source database. -&gt; All the database names, table names and table fields name are...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=222\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"December 10, 2017\">December 10, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"218\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=218\"\n                        title=\"Oracle Notes\">Oracle Notes<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt; Its relational database management system used in enterprise applications. -&gt; Its biggest competitor is Microsoft SQL Server. -&gt; Runs on Windows,Unix,Linux and Mac Operating...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=218\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"December 10, 2017\">December 10, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"213\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=213\"\n                        title=\"To Find the nth highest and least salary\">To Find the nth highest and least salary<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>1. To Find the nth highest salary Eg: General query for all Database SELECT DISTINCT salary FROM emp X WHERE n = ( SELECT COUNT(DISTINCT...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=213\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"December 7, 2017\">December 7, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"211\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=211\"\n                        title=\"High Availability, Load Balancing, and Replication\">High Availability, Load Balancing, and Replication<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>High availability: Database servers can work together to allow a second server to take over quickly if the primary server fails. Load balancing: To allow...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=211\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 29, 2017\">November 29, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"200\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=200\"\n                        title=\"Postgresql Basics\">Postgresql Basics<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>Create Database: -&gt; A database is a named collection of SQL objects (&#8220;database objects&#8221;). Generally, every database object (tables, functions, etc.) belongs to one and...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=200\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 29, 2017\">November 29, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"194\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=194\"\n                        title=\"Roles in Postgresql\">Roles in Postgresql<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt; A role can be thought of as either a database user, or a group of database users, depending on how the role is set...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=194\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 28, 2017\">November 28, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"189\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=189\"\n                        title=\"Useful Linux Commands\">Useful Linux Commands<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>To list all the users: cmd:cat \/etc\/passwd To delete the user in linux: -&gt; we can able to delete the users from ther root user...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=189\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 28, 2017\">November 28, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"178\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=178\"\n                        title=\"Importnat Parameters in postgresql.conf file\">Importnat Parameters in postgresql.conf file<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>listen_addresses (string) -&gt; Specifies the TCP\/IP address(es) on which the server is to listen for connections from client applications. -&gt; The special entry &#8216;*&#8217; corresponds...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=178\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 28, 2017\">November 28, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"176\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=176\"\n                        title=\"Rename Table in Postgresql\">Rename Table in Postgresql<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt; To rename already existing table Syntax: ALTER TABLE table_name RENAME to new_table_name; Eg: Alter table attribute rename to attribute1; -&gt; To rename a column...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=176\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 27, 2017\">November 27, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"170\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=170\"\n                        title=\"Case in postgresql\">Case in postgresql<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt; If we want to retrun boolean value from the query or more than one result based on the condition then we can use case...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=170\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 26, 2017\">November 26, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><article class=\"eael-grid-post eael-post-grid-column\" data-id=\"168\">\n        <div class=\"eael-grid-post-holder\">\n            <div class=\"eael-grid-post-holder-inner\"><div class=\"eael-entry-wrapper\"><header class=\"eael-entry-header\"><h1 class=\"eael-entry-title\"><a\n                        class=\"eael-grid-post-link\"\n                        href=\"https:\/\/blinksql.com\/?p=168\"\n                        title=\"Truncate Table Locks\">Truncate Table Locks<\/a><\/h1><\/header><div class=\"eael-entry-content\">\n                        <div class=\"eael-grid-post-excerpt\"><p>-&gt; To truncate the instance table locks i.e. when one user locked the object and the user wants to lock the same object then dead...<\/p><a\n                            href=\"https:\/\/blinksql.com\/?p=168\"\n                            class=\"eael-post-elements-readmore-btn\">Read More<\/a><\/div>\n                    <\/div><div class=\"eael-entry-footer\"><div class=\"eael-author-avatar\"><a href=\"https:\/\/blinksql.com\/?author=2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=192&#038;d=mm&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' decoding='async'\/><\/a><\/div><div class=\"eael-entry-meta\"><span class=\"eael-posted-by\"><a href=\"https:\/\/blinksql.com\/?author=2\" title=\"Posts by Hannie\" rel=\"author\">Hannie<\/a><\/span><span class=\"eael-posted-on\"><time datetime=\"November 26, 2017\">November 26, 2017<\/time><\/span><\/div><\/div><\/div><\/div>\n        <\/div>\n    <\/article><\/div>\n            <div class=\"clearfix\"><\/div>\n        <\/div>            <div class=\"eael-load-more-button-wrap eael-force-hide\">\n                <button class=\"eael-load-more-button\" id=\"eael-load-more-btn-85af55a\" data-widget-id=\"85af55a\" data-widget=\"85af55a\" data-page-id=\"7\" data-template=\"{&quot;dir&quot;:&quot;lite&quot;,&quot;file_name&quot;:&quot;default.php&quot;,&quot;name&quot;:&quot;Post-Grid&quot;}\" data-class=\"Essential_Addons_Elementor\\Elements\\Post_Grid\" data-layout=\"grid\" data-page=\"1\" data-args=\"orderby=date&amp;order=desc&amp;ignore_sticky_posts=1&amp;post_status=publish&amp;posts_per_page=20&amp;offset=0&amp;post_type=post\" data-max-page=\"2\">\n                    <span class=\"eael-btn-loader button__loader\"><\/span>\n                    <span class=\"eael_load_more_text\">Load More<\/span>\n                <\/button>\n            <\/div>\n            \t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Welcome to DB Administration and Development Vi editor in Linux Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi&hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.10 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Blog - Blink SQL<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blinksql.com\/?page_id=7\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Blog - Blink SQL\" \/>\n<meta property=\"og:description\" content=\"Welcome to DB Administration and Development Vi editor in Linux Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blinksql.com\/?page_id=7\" \/>\n<meta property=\"og:site_name\" content=\"Blink SQL\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-02T02:31:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-768x432.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blinksql.com\/?page_id=7\",\"url\":\"https:\/\/blinksql.com\/?page_id=7\",\"name\":\"Blog - Blink SQL\",\"isPartOf\":{\"@id\":\"https:\/\/blinksql.com\/#website\"},\"datePublished\":\"2017-11-04T12:48:00+00:00\",\"dateModified\":\"2024-01-02T02:31:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blinksql.com\/?page_id=7#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blinksql.com\/?page_id=7\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blinksql.com\/?page_id=7#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blinksql.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blog\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blinksql.com\/#website\",\"url\":\"https:\/\/blinksql.com\/\",\"name\":\"Blink SQL\",\"description\":\" Thinking SQL\",\"publisher\":{\"@id\":\"https:\/\/blinksql.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blinksql.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blinksql.com\/#organization\",\"name\":\"Blink SQL\",\"url\":\"https:\/\/blinksql.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blinksql.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png\",\"contentUrl\":\"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png\",\"width\":280,\"height\":172,\"caption\":\"Blink SQL\"},\"image\":{\"@id\":\"https:\/\/blinksql.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Blog - Blink SQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blinksql.com\/?page_id=7","og_locale":"en_US","og_type":"article","og_title":"Blog - Blink SQL","og_description":"Welcome to DB Administration and Development Vi editor in Linux Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi&hellip;","og_url":"https:\/\/blinksql.com\/?page_id=7","og_site_name":"Blink SQL","article_modified_time":"2024-01-02T02:31:07+00:00","og_image":[{"url":"http:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/Vi-editor-linux-768x432.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blinksql.com\/?page_id=7","url":"https:\/\/blinksql.com\/?page_id=7","name":"Blog - Blink SQL","isPartOf":{"@id":"https:\/\/blinksql.com\/#website"},"datePublished":"2017-11-04T12:48:00+00:00","dateModified":"2024-01-02T02:31:07+00:00","breadcrumb":{"@id":"https:\/\/blinksql.com\/?page_id=7#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blinksql.com\/?page_id=7"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blinksql.com\/?page_id=7#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blinksql.com\/"},{"@type":"ListItem","position":2,"name":"Blog"}]},{"@type":"WebSite","@id":"https:\/\/blinksql.com\/#website","url":"https:\/\/blinksql.com\/","name":"Blink SQL","description":" Thinking SQL","publisher":{"@id":"https:\/\/blinksql.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blinksql.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blinksql.com\/#organization","name":"Blink SQL","url":"https:\/\/blinksql.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blinksql.com\/#\/schema\/logo\/image\/","url":"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png","contentUrl":"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png","width":280,"height":172,"caption":"Blink SQL"},"image":{"@id":"https:\/\/blinksql.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/pages\/7"}],"collection":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blinksql.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":10,"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/pages\/7\/revisions"}],"predecessor-version":[{"id":801,"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/pages\/7\/revisions\/801"}],"wp:attachment":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}