SMF Support > PostgreSQL and SQLite Support

i have a sql system and i whant to mak it a SQLite!

(1/2) > >>

pjn:
i have a sql system and i whant to mak it a SQLite!

how can i do it?


or At least, how can i moved just the table of users?

thanx...

emanuele:
Hi pjn,

with a "sql system" do you mean a MySQL database?
TBH, unless you have a very specific reason I'd suggest you to stay with the MySQL database. From what I've seen (in SMF) SQLite is valid only for very small forums (up 10/20k posts), when the forum becomes bigger and with lots of people the database becomes a huge bottleneck (with page loads over the second).

That said, I managed to convert a couple of SQLite databases into MySQL, but never tried the opposite.
If you are really determined to move to SQLite it should be possible, maybe not straightforward but possible.

pjn:
yes, i meen from mysql...

i whant it, becose my server Restrictive of Queries....


so how can i do it??

thanx...

tinoest:
The following http://www.sqlabs.net/sqliteconverter.php

Is a very good converter , although it does cost $50 .

I am sure there are open source alternatives around if you look.

pjn:
so what i need to search to find it free?

Navigation

[0] Message Index

[#] Next page