Re: [sqlite] "Responsive" website revamp at www.sqlite.org

[Eric Kestler]

Looks quite good and is very readable on my iPhone 6s and iPad Mini 4, both 
portrait and landscape modes.

..Eric

__
Plan A is always more effective when the device you are working on understands 
that Plan B involves either a large hammer or screwdriver
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Version issues on Mac after updating

[Eric Kestler]

I’m a newbie to Sqlite, if that explains the following:

Last year, I installed Sqlite on my Mac; it was version 3.7.6.3:

Server Type: SQLite
Connection Name: testDB
Database File: /Users/ekestler/Dropbox/SyleneDB/test.db
Setting Save Path: /Users/ekestler/Library/Application Support/PremiumSoft
CyberTech/Navicat for SQLite/testDB
Auto connect: NO
Encrypted: NO
Attached Database: NO
Server Version: 3.7.6.3


This past week, after carefully saving all the SQL queries, and exporting
all the tables as CSV files, renamed the sqlite3 executable to sqlite3_old,
and downloaded and installed a newer version on my Mac:

Erics-MacBook-Pro:SyleneDB ekestler$ sqlite3

SQLite version 3.8.10.2 2015-05-20 18:17:19

Enter ".help" for usage hints.

Connected to a *transient in-memory database*.

Use ".open FILENAME" to reopen on a persistent database.

sqlite>


I use a (very old, not available from the vendor anymore) development IDE
product called Navicat Lite; when invoked, it still insists that the
working Sqlite version is 3.7.6.3, and none of the functions I need are
available (instr(), substr(), etc.).


I am NOT a C/C++ developer, and have no idea on how to update versions of
Sqlite via Mac compilation/make; nor can I find step-by-step instructions
for version updates that preserve the data and sql scripts.


Where does Sqlite actually reside when installed on a Mac?


Any help in resolving the version problem, or suggestions on altering where
Navicat Lite is executing the wrong version, would be very welcome.


Thanks,


Eric Kestler

ekest...@gmail.com
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Extended Text Functions

[Eric Kestler]

I'm looking for a release of SQLite that included extended text
functionality; specifically, the SQL Server charindex function.

Is there any reason not to include more text functions into the core SQLite
release? I'm sure many of us would like to see them and ease the burden of
workarounds.

For the record, I'm not a C programmer, and have no idea how to go about
compiling and linking external function libraries using u*ix; I use a Mac,
and while OS/X has a u*ix ancestor, there are no clear step-by-step
instructions on how to compile and link on a Mac that I've found.

Thank you,

Eric Kestler

-- 
Plan A is always more effective when the device you are working on
understands that Plan B involves either a large hammer or screwdriver