osdse

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
osdse [2025/03/20 15:11] – [Website & Data Viewer] davidosdse [2025/04/03 11:40] (current) – [Python] david
Line 60: Line 60:
 ===== Python ===== ===== 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). 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 Ubuntu searching python versions
Line 83: Line 85:
 </code> </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 ===== ===== PostgreSQL =====
Line 169: Line 194:
  
 </code> </code>
-<code html>+<file html index.html>
 <!DOCTYPE html> <!DOCTYPE html>
 <html lang="en"> <html lang="en">
Line 184: Line 209:
   <p>See the sample data:</p>   <p>See the sample data:</p>
   <ul>   <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>           <li>Docs: https://github.com/d-roman-halliday/simple_shop_data_generator</li>
   </ul>   </ul>
Line 190: Line 215:
  
 </html> </html>
-</code>+</file>
  
 Adminer User on DB: Adminer User on DB:
Line 206: Line 231:
 GRANT pg_read_all_data TO simple_shop_adminer_reader; GRANT pg_read_all_data TO simple_shop_adminer_reader;
 </code> </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 ====== ====== Junk ======
  
  • osdse.1742483471.txt.gz
  • Last modified: 2025/03/27 15:42
  • (external edit)