How does database work?!

Question

I’m start working with database and recently i’m writing an accounting program with python. I need to use database in my program but as offline, not depending on a server. So anybody can help me with databases?!😣😫
In addition i’m heard about access but my OS is mac and unfortunately I can’t use that program. I need somebody who know about databases🙄🙏🏻

Answer 1

These are fun, and since you'll need to learn SQL, why not make it fun 😊

SQL Murder Mystery http://mystery.knightlab.com/walkthrough.html

Here's the online version:
https://sql-murder-mystery.datasette.io/sql-murder-mystery

Answer 2

will and i don’t want to put database in online host server

Answer 3

Gotcha, there must have been a miscommunication, from what I understand it'll help to know SQL when working with databases, if you don't already know SQL, the resource I shared was simply a nudge along that learning path, based on my personal experience learning SQL.

Here's what Google has to say about using SQLite with python:

https://www.sqlitetutorial.net/sqlite-python/

Best of luck 👍

Answer 4

thanks, i hope this will be helpful🙏🏻
but i search way to put database on my program dir not connect it to server because when i run program in different OS my database will not be there and program will crash☹️

Answer 5

Vahid.VMB
If you run your python program in another os/system

A new db will be created in that os.and all the data which will be created will be stored in that database.

Answer 6

Vahid.VMB if you use sqlite, it does a database locally in a file. no internet or network needed.

you can code your app/program to check if a database file is available, if none is available, you can create a file and build the sqlite database tables from scratch and then your app can use it.