Python peewee sqlite database open in phpmyadmin?

Question

I started using Peewee for a project to store some information, and I am wondering if there is a way to import the local database into phpmyadmin to be able to better view and interact with the stored data. I created my db like so:

from peewee import *

db = SqliteDatabase('trains.db')

class Train(Model):
    id = AutoField()
    origin = CharField()
    destination = CharField()
    due = TimeField()
    delay = IntegerField()
    est = TimeField()
    cancelled = BooleanField()
    day = CharField()

    class Meta:
        database = db

db.connect()
db.create_tables([Train])

train = Train(origin="LNC", destination="Sheffield", due="17:49", delay=0, est="17:49", cancelled=False,day="monday")
success = train.save()
print(success)


db.close()

This creates a .db file which is not importable to phpmyadmin (I have XAMPP 3.2.4). I came across to SQLite->MySQL converters but they seem to be out of date and I'm not sure if I should just not even use SQLite, as I will have to look at the database in some nicer, visual form.

how many databases , tables , rows and columns we are talking ? — GiovaniSalazar
– GiovaniSalazar, Commented Dec 9, 2019 at 20:05
can't you use database editor like dbeaver or SQLiteBrowser to see database ? There should be even extenison for Firefox to work with SQLite. Probably should be extension also for Chrome. — furas
– furas, Commented Dec 9, 2019 at 20:34
@furas wow I never came across this, this is exactly what I was looking for, thank you! — peterxz
– peterxz, Commented Dec 9, 2019 at 20:47

furas · Accepted Answer · 2019-12-09 21:21:53Z

1

Instead of phpmyadmin you can use database editor like SQLiteBrowser

DBeaver can works with different databases so you can use it at the same time with SQLite and MySQL. It has many functions but I don't rembere if it can transfer data from one type of database to another.

There are even extensions for web browser Firefox like SQLite Manager.

Chrome should have similar extensions.

BTW: Firefox and Chrome keep some informations (ie. bookmarks) in SQLite files.

Long time ago I was using also HeidiSQL but it can't work with SQLite.

edited Dec 9, 2019 at 21:21

answered Dec 9, 2019 at 21:15

furas

149k12 gold badges121 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python peewee sqlite database open in phpmyadmin?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related