1) Can SQLite use cluster? 2) Does SQLite have anything like MySQL Workbench? 3) How to import Excel to SQLite?

Question

1) If MySQL have cluster option, I wonder if SQLite have that option too.

2) I really haven't learn to write in MyQSL. So I do is use the Workbench. If I turning to SQLite, does it have something similar?

3) How to import Excel to SQLite?

Answer 1

http://www.google.co.uk/search?q=sqlite+cluster&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a

http://stackoverflow.com/questions/34403/is-there-a-good-ide-for-sqlite

http://ayende.com/Blog/archive/2008/01/16/Rhino-ETL-2.0.aspx

in other words - use your loaf - it's what it's there for.

w://

Answer 2

King, I've taken a look at your previous questions, and I highly recommend you stop.

You're starting a program from scratch, with perhaps little-to-no knowledge of how databases work. This community will not make this software for you. What you're about to do is get yourself banned.

I recommend some good reading. First, the Stackoverflow FAQ, on how to behave and how to ask questions (and accept answers).

Second, on software design in general, and then on databases in particular (MySQL and SQLite are good starting points). If you're a net person, read the documentation online for both MySQL and SQLite. If you're a book person, go to your local library, I'm sure they will have an introduction level book for MySQL (try the "for Dummies" series, or Apress).

Software design requires for one to stop, get the info, think, plan, and only then execute. I strongly recommend going back and following those steps before asking more of this line of questions here. Once you've done the footwork, you will find the Stackoverflow community is really helpful in figuring out some particulars and how to get you out of tight spots. And we'll be glad to help.

Answer 3

re cluster: No. Even the name suggests "SQL Light" - while offering the basic set of SQL functionality, SQLite shuns advanced features in exchange for being lightweight and easily portable (e.g. single-file databases).