Advertisement:

Author Topic: MySql to SqLite one question  (Read 15846 times)

Offline Cola-Coca

  • SMF Hero
  • ******
  • Posts: 3,534
  • Gender: Male
MySql to SqLite one question
« on: May 15, 2014, 11:58:56 PM »
Hi,

I have a base that is in MySQL and I was wondering if it is possible to convert MySql to SQLite? Is it true thet the database SqLite consumes fewer resources on the server ? Do you recommend this SqLite base to use that is a substitute for MySql ?







Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MySql to SqLite one question
« Reply #1 on: May 16, 2014, 11:35:06 AM »
No don't do it.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Cola-Coca

  • SMF Hero
  • ******
  • Posts: 3,534
  • Gender: Male
Re: MySql to SqLite one question
« Reply #2 on: May 16, 2014, 11:50:58 AM »






Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MySql to SqLite one question
« Reply #3 on: May 16, 2014, 01:48:21 PM »
MySQL preferred format and no way to convert.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: MySql to SqLite one question
« Reply #4 on: May 16, 2014, 04:26:21 PM »
The thing is, most people use MySQL. Most MOD authors (myself included) only develop with MySQL in front.
While SMF has an abstraction layer for database support, it is possible that some things can cause problems with other engines.

I might add that some other forum softwares out there only explicitly support MySQL ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair