Differences

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

--- osdse [2025/03/20 14:43] – [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 162: / Line 187: @@
 </code>
+==== Website & Data Viewer ====
+<code bash>
+cd /var/www/html
+sudo vi index.html
+</code>
+<file html index.html>
+<!DOCTYPE html>
+<html lang="en">
+<head>
+  <meta charset="utf-8">
+  <meta name="viewport" content="width=device-width, initial-scale=1">
+  <title>Home: osdse.roman-halliday.com</title>
+  <link rel="stylesheet" href="styles.css">
+</head>
+<body>
+  <h1>Home : osdse.roman-halliday.com</h1>
+  <p>See the sample data:</p>
+  <ul>
+          <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>
+</body>
+</html>
+</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 ======