Raised This Month: $32 Target: $400
 8% 

Convert .sql to .sq3


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Mish0UUU
Junior Member
Join Date: Jun 2017
Old 06-14-2017 , 16:52   Convert .sql to .sq3
Reply With Quote #1

Dear community!

Im looking for convert my sql table to sqlite but i cant found a software or something else..
Someone have an idea?

I want to use sourcemod database to improve performance and reduce lag because my server using a lot mysql (there lot of lines).

Thanks you.

Last edited by Mish0UUU; 06-14-2017 at 16:53.
Mish0UUU is offline
8guawong
AlliedModders Donor
Join Date: Dec 2013
Location: BlackMarke7
Old 06-15-2017 , 04:44   Re: Convert .sql to .sq3
Reply With Quote #2

http://bfy.tw/CNhW
8guawong is offline
Mish0UUU
Junior Member
Join Date: Jun 2017
Old 06-15-2017 , 05:24   Re: Convert .sql to .sq3
Reply With Quote #3

It's the opposite, sql to sq3.
Mish0UUU is offline
DJ Tsunami
DJ Post Spammer
Join Date: Feb 2008
Location: The Netherlands
Old 06-15-2017 , 05:44   Re: Convert .sql to .sq3
Reply With Quote #4

So did you type "convert mysql to sqlite" into Google and try any of the results?
__________________
Advertisements | REST in Pawn - HTTP client for JSON REST APIs
Please do not PM me with questions. Post in the plugin thread.
DJ Tsunami is offline
Mish0UUU
Junior Member
Join Date: Jun 2017
Old 06-15-2017 , 06:33   Re: Convert .sql to .sq3
Reply With Quote #5

I successful convert in .sqlite but i need .sq3 because sourcemod didnt read this extension.
Mish0UUU is offline
psychonic

BAFFLED
Join Date: May 2008
Old 06-15-2017 , 08:06   Re: Convert .sql to .sq3
Reply With Quote #6

MySQL is generally more performant than SQLite. You shouldn't be getting lag on the server if you are using the threaded query API, and if you are not, SQLite still won't necessarily help you.
psychonic is offline
Miu
Veteran Member
Join Date: Nov 2013
Old 06-15-2017 , 10:31   Re: Convert .sql to .sq3
Reply With Quote #7

Quote:
Originally Posted by Mish0UUU View Post
I successful convert in .sqlite but i need .sq3 because sourcemod didnt read this extension.
Just change the extension to .sq3
Miu is offline
Mish0UUU
Junior Member
Join Date: Jun 2017
Old 06-15-2017 , 15:08   Re: Convert .sql to .sq3
Reply With Quote #8

Quote:
MySQL is generally more performant than SQLite. You shouldn't be getting lag on the server if you are using the threaded query API, and if you are not, SQLite still won't necessarily help you.
I was thinking the sqlite can improve performance because the local database seems to me lighter.

Quote:
Just change the extension to .sq3
Yes i tried but plugin didnt spot database :/
Mish0UUU is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:44.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode