#sqlite3

[notes-alessiosignorini]

PiHole DNS not Responding, disk full

The Internet seemed unreachable at my house. After checking with the provider I determined it was due to my pihole being down.

Logging into the dashboard of my pihole showed "Lost Connection to API". This indicated an issue with the pihole-FTL service.

After logging in the Unify CloudKey where I installed pihole I used df -h to determined that the disk was full

root@UniFi-CloudKey:~# df -h Filesystem Size Used Avail Use% Mounted on aufs-root 2.9G 2.9G 0 100% / udev 10M 0 10M 0% /dev

It was due to 3 things:

apt cache at "/var/cache/apt/archives"

CloudKey backups at "/data/autobackup"

pihole-FTL database at "/etc/pihole/pihole-FTL.db"

You can cleanup the first using "apt-get autoclean". For the second, you can manually delete some of the old backups but perhaps you should set a better backup policy in your CloudKey.

The third one accumulates all the queries ever done against your pihole (18M in the past 2 years for me) unless you set something like MAXDBDAYS=90 in /etc/pihole/pihole-FTL.conf. Mine was 1.4GB.

You can stop the pihole-FTL with "service pihole-FTL stop", delete the file, and restart it, if you want. Or perform a more surgical cleaning directly deleting old entries from the database before restarting it.

[aducator]

View this post on Instagram

New video out on YouTube, link is in bio! Topic: SQLITE 3 for beginners. Learn install/Uninstall and couple of queries. Watch it now! #aducators #learn #sqlite #sqlite3 #beginner #installation #queries #database #sql #developer #coding #dba #backend #backenddeveloper #promote #promoters #likes #followus #followformore #likeourpage #computerscience #computer #technology #freeeducation #course #hunt #quality #content #feedback #poll https://www.instagram.com/p/COZyPdjn4Bm/?igshid=1wzto96pd4zwr

[teguhteja]

Creating Powerful Model Relationships: Django ORM Mastery

Discover how to create powerful #Django model relationships using #ORM. Learn to define models with foreign keys, create views for data handling, and build scalable web applications. Master #database management with Django!

Welcome to the world of Django model relationships! In this post, we’ll explore how to create powerful connections between models using Django’s Object-Relational Mapping (ORM). We’ll dive into foreign keys, model definitions, and view creation to handle related data. Furthermore, we’ll examine how these relationships enhance database management and application scalability. Defining Models with…

Creating Powerful Model Relationships: Django ORM Mastery

[teguhteja]

Django Models: Defining and Exporting Data Structures

Discover the power of #Django models! Learn how to define, export, and manage data structures in your Django projects. Boost your web development skills and create efficient, scalable applications. #DjangoModels #WebDev

Django models serve as the backbone of data management in Django applications. They define the structure of your database tables and provide an intuitive way to interact with your data. In this post, we’ll explore how to define and export it effectively. Understanding Django Models Django models are Python classes that represent database tables. They encapsulate the fields and behaviors of the…

Django Models: Defining and Exporting Data Structures

[pythonprogrammingsnippets]

python add password to sqlite database and then open the db with a password using sqlcipher

import sqlcipher # Connect to the database and set a password conn = sqlcipher.connect("encrypted.db") cursor = conn.cursor() cursor.execute("PRAGMA key='password'") # Create a table and insert data cursor.execute("CREATE TABLE test (id INTEGER PRIMARY KEY, data TEXT)") cursor.execute("INSERT INTO test (data) VALUES ('secret data')") conn.commit() conn.close() # Open the encrypted database conn = sqlcipher.connect("encrypted.db") cursor = conn.cursor() cursor.execute("PRAGMA key='password'") # Read the data from the encrypted database cursor.execute("SELECT * FROM test") result = cursor.fetchall() print(result) conn.close()

[pythonprogrammingsnippets]

python sqlite create db/create table/insert data/select data/delete data/drop table/delete database example

import sqlite3 # Create a database conn = sqlite3.connect('sample_database.db') # Create a sample table cursor = conn.cursor() cursor.execute('''CREATE TABLE sample_table (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)''') # Insert sample data into the table cursor.execute("INSERT INTO sample_table (id, name, age) VALUES (1, 'John Doe', 30)") cursor.execute("INSERT INTO sample_table (id, name, age) VALUES (2, 'Jane Doe', 25)") # Commit changes conn.commit() # Select all data from the table cursor.execute("SELECT * FROM sample_table") rows = cursor.fetchall() for row in rows: print(row) # Delete sample data from the table cursor.execute("DELETE FROM sample_table WHERE id = 1") # Commit changes conn.commit() # Delete the sample table cursor.execute("DROP TABLE sample_table") # Commit changes conn.commit() # Close the connection conn.close() # Delete the sample database import os os.remove('sample_database.db')

[lutai256rokuta]

【SQLite3】SQLで条件分岐！列の値を評価して結果を返す（CASE）

以前、Pythonで条件分岐をするための記事を投稿しました。 データベースの操作でも、SQLを発行することで条件分岐を行うことができます。 例えば、【項目Aの値が項目Bよりも大きかったらフラグを立てたい】など、使い方は様々です。 本日は、CASEの基本的な記述方法をご紹介したいと思います。 条件分岐の基礎：CASEの書き方 基本的な書き方 以下のように記述します。 まずは、SELECT文で確認していきたいと思います。 SELECT 項目1,項目2, CASE WHEN 条件1 THEN 条件1を満たしたら実行される処理 ELSE 条件を満たしていないに実行される処理 END FROM…

View On WordPress

[lutai256rokuta]

【SQLite3】データベースに過去N営業日間の出来高最小値（プコツン値）を格納するSQLを考えた

プコツンの定義について 免責事項（補足） プコツンについて まずは、ヨコワケ様のTwitterから引用です。 どういったチャートの時にプコツンとなるか？が、説明されています。 蛇足かもしれませんが、ヨコワケ様のアカウントは、新旧あるようです。 プコツン発案当初は、旧アカウントで展開されていました。 旧（@yokowakefes）ヨコワケ 新（@ShiningBlue_SKY）新ヨコワケ 当ブログ内での、プコツンの定義 ②のフラグは、後で考えるとして、まずは①を進めていきます。 いろんな投資スタイルの方がいると思いますが、当ブログの中では、１ヶ月程度を監視することにしました。 そのため、過去28営業日間の出来高最小値を、システム的に格納していく仕様で、開発を進めていきたいと思います。 関連ツイート（一部抜粋） 自分で言ってて目から鱗だったのは、「出来高が少ないと…

View On WordPress