Can I connect to a Raspberry Pi running sqlite from my PC on the same network?

I'm sorry if this question has been asked before - I couldn't find it on the Forum.

I'm trying to connect to an 'sqlite3' database running on a Raspberry Pi on my home network from my PC which is running Heidi on the same network. My first question is this possible? And if it is, has anyone got an example of how to do it? I can connect to a remote server running MySQL on my ISP so I know the connection is good.

Kind regards, David.

You will need to access the SQLite file from HeidiSQL. It should be sufficient to have some smb share or similar on the raspi.

Thanks for the swift response. I've now setup samba on my Pi and can access the file structure from my PC. Can I ask which Network Type I select in the Heidi dropdown?

I've made progress and can now connect Heidi to the sqlite dB on my Raspberry Pi. If I try to insert a new row I get this error. I've checked the file permissions on the dB and they are RWX (775) Any suggestions?

According to this thread, the database file may be encrypted. Or it's already opened in another process?

I've made further progress and managed to get Heidi to connect to a sqlite db on a remote Raspberry Pi on my home network. I can open a new or an existing table and Add new column and Save the table away. However, if I try to Remove a column and then try to Save the table I get this error message.

I think I've found the answer - You cannot use the ALTER TABLE statement to drop a column in a table. Instead you will need to rename the table, create a new table, and copy the data into the new table.

Obviously this is a lot different to MYsql where you can do things like that.

Is that correct or have I misunderstood something?

Yes that may be the case. HeidiSQL's DDL queries in the table editor do not support SQLite.