How can I connect to sqlite

Wappler General How To
#1

does anyone know ? how can I connect to sqlite database file

sqll
sqll.png1136×1081 52.2 KB

#2

Hi Serhat,
Try entering the full path to the file.

1 Like
#3

yeap teodor , solved …

#4

thank you very much

#5

I have tried that. I am noticing the file name extension is db. Is that the only extension it will take? Not *.sqlite3? Can I add a path to the file in my web directory or only on the computer. I have tried putting the database file in the Wappler project directory and it will say the database is connected but will not find any tables when I try to build the query. Any other suggestions. Perhaps you can attach a same db in case the utility I am using isn’t creating the proper structure. Thanks.

#6

Have you added a ‘Database Connection’ step before your query in the Server Connect Steps?

#7

Absolutely. BC I know this step from using MySQL. TY

#8

what type is full path?
http? or ftp?
I already tried both of them.
image
but this error
Please help me.
thank you

#9

Hi @Akio_Sensei

It’s the full server path, like:
Screenshot_12

As per your error - do you have the required PDO drivers for sqlite installed on your server?

#10

Hello

Yes, I already fixed the issue and worked fine now.
thank you.

1 Like