1、SQLite Expert(Free, $59)，后边9个特效是收费版本具有的，官方网址：http://www.sqliteexpert.com/
–ManageSQLite3databases:createdatabase,view/changeparameters.
–Checkintegrity,reindexalltables,transactionsupport.
–SupportsattacheddatabasesandSQLiteextensions.
–Managetables:create,delete,rename,reindex.
–Restructuretables:fields,indexes,foreignkeys,uniqueandcheckconstraints,triggers.
–Manageviews:create,delete,rename,restructure.Manageviewtriggers.
–Supportstemporarytablesandviews.
–AdvancedSQLeditorwithcodecompletionandsyntaxhighlighting.
–Advanceddataeditingcapabilitiesinthegrid:image,BLOBandtexteditors.
–Customandpredefineddatatypes.
–Copy/Pasterecordsandtablesbetweendatabasesviaclipboard.
–FullUnicodesupport.
–Customizethelookandfeeloftheapplicationusingskins.
–*VisualSQLQueryBuilder.
–*Copytablesbetweendatabasesusingdraganddrop.
–*Supportsencrypteddatabases.
–*SupportsSQLiteautoextensions.
–*ExportdatatoExcel,XML,HTML,CSV,TSV,ADOdatasources,SQLscript,SQLitedatabase.
–*ImportdatafromADOdatasource,SQLscript,SQLite.
–*SendthecontentsofanygridtoprinterorexportittoaPDFfile.
–*GenerateSELECT,INSERT,UPDATEandDELETEstatementsbasedonthevisiblefieldsonthecurrenttable.
– *Lua and Pascal scripting support.2、SQLite Administrator(Free)，免费软件，支持中文，官方网址：http://sqliteadmin.orbmu2k.de/
–Create/Modify/DeleteTablesbyWizard
–Create/Modify/DeleteIndicesbyWizard
–Create/Modify/DeleteViewsbyWizard
–Create/Modify/DeleteTriggersbyWizard
–SQLCodeCompletionthatsupportstablealiases
–SQLCodeHighlighting
–SQLErrorLocating
–ImportDatafromCSVFiles
–ExportData(XLS/CSV/HTML/XML)
–StoreUserQueriesintoDatabase
–SearchforUserQueries
–StoreImagesintoBlobFields(JPG/BMP)
–ShowSQLofeachDatabaseItem
–MigrateSQLite2DatabasestoSQLite3
– Try to keep Indices and Triggers after modifying a Table3、SQLite Developer(Free, $49)，似乎是国人开发的软件，官方网址：支持中文http://http://www.sqlitedeveloper.com/
–PowerSQLEditor(SqliteSqlSyntaxHighlight;Sqlhistory;Sqlkeywordautocomplete;Parenthesismatching;Table/View/Field;Autocomplete;LiveSqlSyntaxCheck;Unicodesupport)
–SQLFormatter
–Supportsansi,unicodedataencodinganddecoding.
–CustomizableDataTypeMapping.
–Executemultiplesqlseparatedbysemicolon.
–Executesqlscriptwithparameters.
–MasterDetailBrowser.
–TestDataGenerator
–GenerateDatabaseSchemaReport
–SQLMonitor.
–VisualQueryBuilder.
–Visualtables,views,trigger,foreignkey,check,uniquecheckandindexmanagement.
–ViewandeditfieldasText,Hex,HTMLorbmp,jpeg,gif.
–Viewandedittemporarytables,viewsandtriggers.
–MemoryDatabasesupport
–Queryplan.
–LiveUpdate.
–Exportdatatosql,csv,excel,word,html,xml.
–Import/Export(Importdatafromsql,csv,sqlitedatabaseandadodatasource;Extractdbschemaanddata;PasteDatafromClipboard)
–Backup/RestoreDatabase.
–Treeviewstyledbexplorerwithsmartfilter
–AttachandDetachdatabases
–supportencryptanddecryptdatabase(encrypteddatabasesarecompatiblewithSystem.Data.SQLite)
–RTreeandICUsupport
–FindinDatabaseSchema
–Cancellong-timequery
–Supportloadableextensionandvirtualtable
– Multi Languages support(English, Japanese, Simple Chinese)4、Sqlite Spy(Free)，免费的，用起来不错，官方网址：http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
–DatabaseataGlance:Theschematreeviewdisplaysallitemscontainedinadatabase,includingtables,columns,indexesandtriggers.PressF5toupdatetheschematree,double-clickatableorviewtodisplayitsdata,usethecontextmenuforfrequentlyusedcommands.
–GridCellEditing:Tablecellsareeditableinthegrid:Displayatableviatheschematreeview,selectacellandpressF2toinvoketheeditor.Thenmodifyandconfirmtowriteyourchangesbacktothetable.
–DataTypeDisplay:ThenativeSQLdatatypesaredisplayedwithdifferentbackgroundcolorstohelpdetecttypeerrors.TypeerrorscancauseperformancedegradationorwrongSELECTresultsetsifNULLvaluesareconfusedwithemptystrings.
–FullUnicode:SQLiteSpyfullysupportsSQLite’sUnicodecapabilities.DatadisplayandentryiscompletelyrealizedasUnicode,includingSQLcommands.
–MultipleSQLEdits:ModerntabsareusedtoeditanddisplaymultipleSQLqueriesforeasycomparisonofquerystatementsandresults.SQLqueriesareexecutedbytypingorloadingthemintotheSQLedit.ThenpressF9torunthequery,orCTRL+F9torunthecurrentlineorselectiononly.
–TimeMeasurement:SQLexecutiontimeisautomaticallymeasuredanddisplayedtohelpoptimizequeries.
–RegularExpressions:TheSQLkeywordREGEXPissupportedandaddsthecompleteregularexpressionsyntaxofPerl5.10toSQLiteSpy.TheimplementationwasrealizedusingtheDIRegExlibrary.
MathematicalSQLFunctions–ThefollowingmathematicalSQLfunctionsareavailableinadditiontotheSQLitedefault:ACOS(),ASIN(),ATAN(),ATAN(),ATAN2(),CEIL(),CEILING(),COS(),COT(),DEGREES(),EXP(),FLOOR(),LN(),LOG(),LOG(),LOG2(),LOG10(),MOD(),PI(),POW(),RADIANS(),SIGN(),SIN(),SQRT(),TAN(),TRUNCATE().
–DataCompression:TheSQLfunctionsCOMPRESS()applieszlib’sdeflatetoanytextorBLOBvalue.Therawdeflatedatastreamisreturned.UNCOMPRESS()inflatesthisstreambacktotheoriginal.Integers,Doubles,andNullsarereturnedunchanged.
–CompactResultStorage:TheinternaldatastoragemechanismusesSQLite’snativedatatypesforoptimalcompatibility.Asaresult,SQLiteSpyusesfarlessmemorythanotherSQLitemanagersandhandleslargetablesmuchmoreefficiently.
–Built-inSQLiteEngine:SQLiteSpycomesasasinglefileexecutablewiththeSQLitedatabaseenginealreadybuildintotheapplication.ThereisnoneedtodistributeanyDLLs,whichmakesSQLiteSpyeasytodeploywithcustomers.
–EncryptionSupport:SQLiteSpycanreadandmodifyencrypteddatabasefilesgeneratedbyDISQLite3.DISQLite3implementsitsownnativeAESencryptionwhichisnotcompatiblewiththecommercialSQLiteEncryptionExtension(SSE)oranysuchimplementationofferedbyother3rdparties.
–EasyInstall&Uninstall:TorunSQLiteSpy,justextracttheSQLiteSpy.exefiletoanydirectoryandexecutethefile.Noinstallationisneeded–whenfirststarted,theprogramcreatesasinglefileSQLiteSpy.db3(aSQLite3database)tostoreoptionsandsettings.Itdoesnotwriteanyotherfilesortotheregistry.Uninstallingisassimpleasdeletingtwofilesonly:Theapplication’sexecutableanditsoptionsdatabasefile.
– Freeware: SQLiteSpy is Freeware for personal and educational use. If you are using SQLiteSpy commercially, your donation is welcome to promote the ongoing development of this software. Thank you!5、SQLiteManager(开源)，所谓基于Web的SQLite管理工具，官方网址：http://www.sqlitemanager.org
–Managementofseveraldatabases(Creation,accessorupload)
–Managementoftheattacheddatabases
–Create,editanddeletetablesandindexes.
–Insert,edit,deleterecordsinthesetables
–ManagementoftheView,possibilitiesofcreatingaviewfromaSELECT
–ManagementofTrigger
–Managementoftheusersdefinedfunctions,thesefunctionsareincontinuationusableintherequestsmanual,asintheformofinsertion/modificationofdata
–Manualrequestandfromfile,itispossibleofdefinedtheformatoftherequests,sqliteorMySQL;aconversionisdoinginordertodirectlyimportaMySQLbaseinSQLite.
–Importingofrecordsfromaformattedtextfile
–Exportofthestructureandthedata
– Choice of several display skin6、SQLite Database Browser(免费)，支持多平台，windows平台下的更是只有一个exe文件，官方网址：http://sqlitebrowser.sourceforge.net/
–Createandcompactdatabasefiles
–Create,define,modifyanddeletetables
–Create,defineanddeleteindexes
–Browse,edit,addanddeleterecords
–Searchrecords
–Importandexportrecordsastext
–Importandexporttablesfrom/toCSVfiles
–Importandexportdatabasesfrom/toSQLdumpfiles
–IssueSQLqueriesandinspecttheresults
– Examine a log of all SQL commands issued by the application