Differences

This shows you the differences between two versions of the page.

--- osdse [2025/03/20 15:08] – [Apache] david
+++ osdse [2025/04/03 11:40] (current) – [Python] david
@@ Line 60: / Line 60: @@
 ===== Python =====
 If you need multiple versions/more control, go for [[https://github.com/pyenv/pyenv|pyenv]]. But in most cases the latest stable will be fine (right how that's 3.12).
+==== Basic (one python) ====
 Ubuntu searching python versions
@@ Line 83: / Line 85: @@
 </code>
+==== pyenv (multiple python versions) ====
+Prerequisite for ''pyenv'' to build some things:
+<code bash>
+sudo apt-get install build-essential
+</code>
+Install ''pyenv'' (not an ubuntu package):
+<code bash>
+curl https://pyenv.run | bash
+</code>
+Make the changes to ''.bashrc'' as suggested.
+Then install the python version you wish to have:
+<code bash>
+pyenv install 3.11
+</code>
+View python versions:
+<code bash>
+pyenv versions
+</code>
 ===== PostgreSQL =====
@@ Line 169: / Line 194: @@
 </code>
-<code html>
+<file html index.html>
 <!DOCTYPE html>
 <html lang="en">
@@ Line 184: / Line 209: @@
   <p>See the sample data:</p>
   <ul>
-          <li>Explore: <a href="sample_data_explore/">explore</a></li>
+          <li>Explore: <a href="sample_data_explore/">explore</a> (username: <code>simple_shop_adminer_reader</code> password: <code>simple_shop_adminer_reader_password</code>)</li>
           <li>Docs: https://github.com/d-roman-halliday/simple_shop_data_generator</li>
   </ul>
@@ Line 190: / Line 215: @@
 </html>
-</code>
+</file>
 Adminer User on DB:
 <code bash>
+sudo -i -u postgres psql
 </code>
 <code sql>
 CREATE USER simple_shop_adminer_reader  WITH ENCRYPTED PASSWORD 'simple_shop_adminer_reader_password';
+\c simple_shop;
+-- Grant privileges for simple_shop_adminer_reader (read-only access)
+GRANT CONNECT ON DATABASE simple_shop TO simple_shop_adminer_reader;
+GRANT USAGE ON SCHEMA public TO simple_shop_adminer_reader;
+GRANT pg_read_all_data TO simple_shop_adminer_reader;
 </code>
+Adminer:
+<code bash>
+sudo mkdir -p sample_data_explore
+cd sample_data_explore
+sudo wget https://github.com/adminerevo/adminerevo/releases/download/v4.8.4/editor-4.8.4.php
+sudo vi index.php
+</code>
+<file php index.php>
+<?php
+function adminer_object() {
+  class AdminerSoftware extends Adminer {
+    function name() {
+      // custom name in title and heading
+      return 'Postgres Test Adminer Editor';
+    }
+    function database() {
+      // database name, will be escaped by Adminer
+      return 'simple_shop';
+    }
+    function loginForm() {
+      echo "<table cellspacing='0' class='layout'>\n";
+      echo $this->loginFormField('username', '<tr><th>' . lang('Username') . '<td>', '<input type="hidden" name="auth[driver]" value="pgsql"><input type="hidden" name="auth[server]" value="127.0.0.1"><input name="auth[username]" id="username" value="' . h($_GET["username"]) . '" autocomplete="username" autocapitalize="off">' . script("focus(qs('#username'));"));
+      echo $this->loginFormField('password', '<tr><th>' . lang('Password') . '<td>', '<input type="password" name="auth[password]" autocomplete="current-password">' . "\n");
+      echo "</table>\n";
+      echo "<p><input type='submit' value='" . lang('Login') . "'>\n";
+      echo checkbox("auth[permanent]", 1, $_COOKIE["adminer_permanent"], lang('Permanent login')) . "\n";
+    }
+  }
+  return new AdminerSoftware;
+}
+include './editor-4.8.4.php';
+</file>
 ====== Junk ======