how to use sqlite

36 views
Skip to first unread message

湖南老師

unread,
Mar 20, 2016, 1:51:20 PM3/20/16
to redbeanphp
Dear sir
i use 
R::setup('sqlite:/tmp/t1.db'); //sqlite
but i can't create any data

how to connect sqlite database

may i create t1.db first

tks

yauger

Martien de Jong

unread,
Mar 20, 2016, 2:40:00 PM3/20/16
to redbe...@googlegroups.com
Hi,

What I did was use phpliteadmin https://www.phpliteadmin.org/ to create the database first.

Hope it helps.

Greetings.

--
Best regards,

Martien de Jong - martiendejong.nl

--
You received this message because you are subscribed to the Google Groups "redbeanphp" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redbeanorm+...@googlegroups.com.
To post to this group, send email to redbe...@googlegroups.com.
Visit this group at https://groups.google.com/group/redbeanorm.
For more options, visit https://groups.google.com/d/optout.

Cesar Marinho

unread,
Apr 9, 2018, 7:18:41 AM4/9/18
to redbeanphp
you can use sqlite3 console app:
sqlite3

and so save the empty database with the filename you need.
.save test.db
.quit

dont forget read .help before. 8)
and after this just sqlite3 test.db

readbean saves all touye tables in database while you are using it, is amazing!

Good Luck!

Cesar Marinho

unread,
Apr 9, 2018, 7:18:41 AM4/9/18
to redbeanphp
you can use sqlite3 console app:
sqlite3

and so save the empty database with the filename you need.
.save test.db
.quit

dont forget read .help before. 8)
and after this just sqlite3 test.db

readbean saves all touye tables in database while you are using it, is amazing!

Good Luck!

Em domingo, 20 de março de 2016 14:51:20 UTC-3, 阿堯老師 escreveu:
Reply all
Reply to author
Forward
0 new messages