Python Forum
Create database in python module ?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Create database in python module ?
#1
Is there a way to create
database in python not confuse
with connect to external database.

And then write, import to and from it
to and from excel ?

Like how .Net you can create a
database in Visual Studio ?
Reply
#2
can you elaborate more on what your goal is?
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#3
(Sep-02-2019, 04:45 PM)buran Wrote: can you elaborate more on what your goal is?

Yes the goal is to create exe to store
data in the embedded program and run SQL statements
or when connecting to externally SQL, can still create
tables internally that can help or assist with creating
Creative programs ?
Reply
#4
you can create sqlite3 database. support for it comes with the standard library
https://docs.python.org/3.7/library/sqlite3.html

you can store on disk for persistence or create in RAM
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#5
(Sep-02-2019, 05:01 PM)buran Wrote: you can create sqlite3 database. support for it comes with the standard library https://docs.python.org/3.7/library/sqlite3.html you can store on disk for persistence or create in RAM

Nice, this is embedded into the executable or is separate ?
Reply
#6
(Sep-05-2019, 12:00 AM)Johnse Wrote: Nice, this is embedded into the executable or is separate ?
Not sure what you mean here...
But it is part of Standard Library. i.e. no need to install extra packages. Just python is enough.
sqlite3 module in the docs: https://docs.python.org/3/library/sqlite3.html
small tutorial: https://pymotw.com/3/sqlite3/index.html
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Should I se SQLite to create a simple High-scores database? shaanukstar123 3 2,593 Nov-08-2019, 07:45 PM
Last Post: snippsat
  re module: want a regexhttps://python-forum.io/Thread-re-module-want-a-regex Skaperen 4 2,529 Sep-19-2019, 10:54 PM
Last Post: Skaperen

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020