[sqlite] System.Data.SQLite.Core and Core-Linux version Mismatch [nuget]
When trying to install the current stable NuGet of System.Data.SQLite.Core I get the following error: Error Unable to resolve dependencies. 'System.Data.SQLite.Core 1.0.112' is not compatible with 'System.Data.SQLite.Core-Linux 1.0.110 constraint: System.Data.SQLite.Core (= 1.0.110)'. As I understand, to develop cross-platform with this NuGet both packages are needed, is that correct? It seems that System.Data.SQLite.Core-Linux 1.0.110 and is the latest stable for that package and System.Data.SQLite.Core 1.0.110 is not available. It seems that I can neither update the Linux package nor install a previous version of SQLite.Core. What is the suggested path forward? -- Jonathon K. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Many ML emails going to GMail's SPAM
On 11/21/2017 08:20 PM, Keith Medcalf wrote: > Strict RFC compliance is very simple: Which explains why virtually every email client on mobile devices is unable to send email that complies with the relevant RFCs. Using RFC-compliance as a spam detection tool is useful, because it eliminates 100% of the spam out there. Unfortunately, it also eliminates at least 70% of the legitimate email out there. jonathon signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Typical suffixes of sqlite database files
On 20/10/2016 23:17, Rolf Ade wrote: > What suffixes to sqlite database files do you use or see in the wild? Too many for suffix identification to be a viable option. One program I use, has 20 different suffixes, for the SQLite databases that it utilizes. Most of its competitors use between 3 and 5 suffixes for the SQLite databases that they utilize. Use the magic number. Much more reliable, easier to maintain, and less chance of a false positive. jonathon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Whish List for 2015
On 21/12/14 09:47, big stone wrote: that I hope may help end-user/students popularity [2] [2] http://db-engines.com/en/ranking_trend The methodology used by that site is tilted in favour of big data, and complex databases. Consequently, even if there are ten million SQLite databases for every non-SQLite database, SQLite won't rank very high. SQLite shines something that is created for a one time use, and then can be deleted, because it is no longer needed. Which is not to say that SQLite is not a good database engine. But for quick and dirty and work, SQLite is more suitable than Oracle, MySQL, Microsoft SQL Server, or PostgreSQL. (Most databases are created for a one time use, where quick and dirty is the most important criterion. Then, because of their usefulness, they are re-used, and made even more complex, and relied upon for more things. Until the original database has become "mission critical", without anybody noticing it. Fortunately for all, SQLite can scale to that usage, without undue damage.) sqlite4 is dead because sqlite3 did progress quicker than expected ? From reading the blogs, etc, SQLite4 is "experimental" and to be used only when you don't object to losing everything --- OS, database, applications, hardware --- on your system, and everything that is networked to it, and all backups made since the dawn of the computer age. Those same sources imply that things that work, are useful, and _will not break_ existing setups, will be migrated to SQLite 3.x. jonathon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New kids on block the SQLite Master Suite.
On 29/10/14 19:46, Billy Huynh wrote: > the SQLite Master Suite. > It mainly designed to handle a very large database file with lightning fast > import and export of data and Support for Windows Server 2003, which EOLs on Bastille Day 2015, but no support for Windows Server 2012? If that really is the case, then you just shot yourself in the foot. No rational Sysadmin is going to install something on a platform that they will be migrating away from within a year. (Admins of legacy hardware and software won't install any new software, because they won't be able to fix any resulting issues.) jonathon signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Strategies for protecting sql queries
Hello, I am using a sqlite database to store/retrieve sensitive information. I am currently encrypting the database to secure the actual data, but I am still concerned about my actual sql statements. The sql statements themselves are left in plaintext in memory so if someone was ambitious enough, they could just attach a debugger to my process and see the plain strings. Does sqlite provide any functionality to protect against this? I know that some databases have encrypted stored procedures. Does sqlite have something similar? J ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite and OpenOffice
On Thu, Feb 11, 2010 at 11:11, Phil Hansen - Info wrote: > Found that OO base can be used to access Sqlite. > However the literature is a bit vague. > I downloaded the .zip file which should be copied to > openoffice1.1/user/uno_packages. Your problem is right there. The package you downloaded is for OOo 1.x, and you are using OOo 3.x. That package, and the instructions that go with it, are obsolete. Install libsqliteodbc in the Ubuntu repository. (I've forgotten if SQLite also has to be installed. I automatically installed both that and SQLite Browser.) One of the problems with using OOo for SQLite databases, is that the wizard keeps getting in the way. :( Note: OOo creates everything in Base, then copies the content to the database that one is actually using. Likewise, everything is edited in a Basse database, then copied to the database that is actually being used. jonathon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!
Thanks Dan for the reply, How would I go about creating a sql dump? As for the ORDER BY clause, I do this: SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id = d.id AND c.e_id = e.id ORDER BY a.some_other_value ASC; Although a.some_other_value is not displayed in the tableA below, I forgot to add it. So, I add the ORDER BY clause on a.some_other_value and it returns a ton of records (mostly duplicates). I am pretty sure this is a bug because if I wrap this query inside of a subquery and perform the ORDER BY on the subquery, everything works. This is what WORKS: SELECT * FROM ( SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id = d.id AND c.e_id = e.id ) ORDER BY a.some_other_value ASC; So for now, I am just leaving my original query inside the subquery to fix it. However, I wouldn't mind posting some debugging information if it will help fix the bug. Thanks, J On Tue, Mar 3, 2009 at 8:23 PM, Dan wrote: > > On Mar 4, 2009, at 4:41 AM, Jonathon wrote: > > > Hello, > > > > I am executing a query such as: > > Can you post a database (or sql dump thereof) to run your queries > against? Also say exactly what ORDER BY clause you are adding to > the end of the query that causes it to return incorrect results? > > Thanks, > Dan. > > > > > 1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c > > INNER > > JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id > > AND > > a.d_id = d.id AND c.e_id = e.id; > > 2. > > 3. CREATE TABLE tableA ( > > 4. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > > 5. b_idINTEGER NOT NULL, > > 6. c_idINTEGER NOT NULL, > > 7. d_idINTEGER NOT NULL > > 8. ) > > 9. > > 10. CREATE TABLE tableB ( > > 11. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT > > 12. ); > > 13. > > 14. CREATE TABLE tableC ( > > 15. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > > 16. e_idINTEGER NOT NULL > > 17. ); > > 18. > > 19. CREATE TABLE tableD ( > > 20. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT > > 21. ); > > 22. > > 23. CREATE TABLE tableE ( > > 24. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT > > 25. ); > > > > > > This seems to be returning the correct records. However, when I > > append an > > ORDER BY at the end of the query, it seems to be changing the number > > of > > records that are returned back to me. From my understanding, an > > ORDER BY > > can not change the number of records correct? If I do not use the > > ORDER BY, > > I get around 150 records. If I do an ORDER BY on any column that > > is not in > > tableA, the number of records blows up (~4k) and there are duplicates. > > > > Any ideas? > > > > I thought that it was because of a buggy parser, so I wrote the > > query again > > as: > > > > > > 1. SELECT * FROM tableA a > > 2. INNER JOIN tableB b > > 3. ON a.b_id = b.id > > 4. INNER JOIN tableD d > > 5. ON a.d_id = d.id > > 6. INNER JOIN tableC c > > 7. LEFT JOIN tableE e ON c.e_id = e.id > > 8. ON ON a.c_id = c.id > > > > and it still gave me the same results... > > > > Thanks, > > J > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!
Hello, I am executing a query such as: 1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id = d.id AND c.e_id = e.id; 2. 3. CREATE TABLE tableA ( 4. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 5. b_idINTEGER NOT NULL, 6. c_idINTEGER NOT NULL, 7. d_idINTEGER NOT NULL 8. ) 9. 10. CREATE TABLE tableB ( 11. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT 12. ); 13. 14. CREATE TABLE tableC ( 15. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 16. e_idINTEGER NOT NULL 17. ); 18. 19. CREATE TABLE tableD ( 20. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT 21. ); 22. 23. CREATE TABLE tableE ( 24. id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT 25. ); This seems to be returning the correct records. However, when I append an ORDER BY at the end of the query, it seems to be changing the number of records that are returned back to me. From my understanding, an ORDER BY can not change the number of records correct? If I do not use the ORDER BY, I get around 150 records. If I do an ORDER BY on any column that is not in tableA, the number of records blows up (~4k) and there are duplicates. Any ideas? I thought that it was because of a buggy parser, so I wrote the query again as: 1. SELECT * FROM tableA a 2. INNER JOIN tableB b 3. ON a.b_id = b.id 4. INNER JOIN tableD d 5. ON a.d_id = d.id 6. INNER JOIN tableC c 7. LEFT JOIN tableE e ON c.e_id = e.id 8. ON ON a.c_id = c.id and it still gave me the same results... Thanks, J ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Odd very SLOW query in SQLITE - Optimizer is not working!?
Hello All, I have a simple query that seems to be going very very very slow. I am not sure why sqlite is behaving this way, which is why I decided to burden you guys with my question. My guess is that the query optimizer might not be able to decipher what exactly I want to do, and thus computes some inefficient query. Here is my query: SELECT * FROM tableR r INNER JOIN tableU u ON u.id = r.u_id LEFT JOIN tableP p ON u.p_id = p.id ORDER BY p.p_name; CREATE TABLE tableR ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, u_id INTEGER NOT NULL ); CREATE TABLE tableU ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, p_id INTEGER NOT NULL ); CREATE TABLE tableP ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, p_name INTEGER NOT NULL ); CREATE INDEX p_name_index ON tableP (p_name); CREATE INDEX p_id_index ON tableU (p_id); CREATE INDEX u_id_index ON tableR (u_id); tableR has about 5 million records. tableU has 100k records. table P has 1k records. It's very weird. If I change the last join to an INNER JOIN, everything works great. Any information on how I could improve this query would greatly help. I know it can't be THIS slow.. Thanks, J ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Exporting database to CSV file
Thanks for the replies... Actually, it seems my requirements have changed.. Is there a way to do this entirely through php? I would like to make a query on a table and write the results to a csv file so that the user can have the option of downloading it. Has anyone ever done something similar to this? Thanks J On Tue, Jan 6, 2009 at 8:02 AM, Alexey Pechnikov wrote: > Hello! > > В сообщении от Tuesday 06 January 2009 15:33:42 Sylvain Pointeau > написал(а): > > The import has the big limitation to not be able to import the file when > a > > field is on multiple lines.I don't know if this is the same for the > > export... > > See virtualtext extension from spatialite project. > > Best regards, Alexey. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Exporting database to CSV file
Awesome. Thanks for the quick reply Deech :) J On Mon, Jan 5, 2009 at 2:34 PM, aditya siram wrote: > Open the sqlite database using: > > sqlite3 database.sqlite > >> .mode csv > >> .output yourfilename > >> your-sql -query > > -deech > > On Mon, Jan 5, 2009 at 4:21 PM, Jonathon wrote: > > > Hello all, > > > > I am interested in exporting a particular table to a CSV file. I've > > browsed > > google for a bit, but all I could find is third party programs. I was > > hoping this functionality was provided in sqlite and that it was super > > duper > > fast :) > > > > Thanks! > > > > J > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Exporting database to CSV file
Hello all, I am interested in exporting a particular table to a CSV file. I've browsed google for a bit, but all I could find is third party programs. I was hoping this functionality was provided in sqlite and that it was super duper fast :) Thanks! J ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Creating Histogram fast and efficiently :)
Thanks Russell :) It works great. J On Wed, Dec 31, 2008 at 5:52 AM, Russell Leighton wrote: > > create table numbers (val integer); > > insert into numbers values (1); > insert into numbers values (5); > > > sqlite> select * from numbers order by val; > 1 > 5 > 10 > 12 > 12 > 15 > 20 > 20 > 20 > > > > select case when val < 10 then 1 when val >=10 and val < 20 then 2 > else 3 end as bin, >count(1) as c > from numbers group by bin; > > > sqlite> select case when val < 10 then 1 when val >=10 and val < 20 > then 2 else 3 end as bin, >...> count(1) as c >...> from numbers group by bin; > 1|2 > 2|4 > 3|3 > > > On Dec 31, 2008, at 6:16 AM, Jonathon wrote: > > > Hello all, > > > > I have a column of numbers in a table, and I was wondering if it is > > possible > > to create a histogram out of it fast and efficiently? > > > > For example, assuming the data in the column is: 1, 5, 10, 12, 12, > > 15, 20, > > 20, 20.. I would like to return: > > > > 'less than 10' --> 2 > > 'less than 20 and greater than or equal to 10' --> 4 > > 'great than or equal to 20' --> 3 > > > > I hope that makes sense. I checked all over Google, and it seems that > > different databases seem to tackle this problem differently. So.. I > > was > > just curious how sqlite can help me make this calculation fast :) > > > > Thanks, > > J > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Creating Histogram fast and efficiently :)
Hello all, I have a column of numbers in a table, and I was wondering if it is possible to create a histogram out of it fast and efficiently? For example, assuming the data in the column is: 1, 5, 10, 12, 12, 15, 20, 20, 20.. I would like to return: 'less than 10' --> 2 'less than 20 and greater than or equal to 10' --> 4 'great than or equal to 20' --> 3 I hope that makes sense. I checked all over Google, and it seems that different databases seem to tackle this problem differently. So.. I was just curious how sqlite can help me make this calculation fast :) Thanks, J ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Convert integer IP address to string IP address in Sqlite
Hello all, I was just curious if there is a way to convert an integer representation of an IP address that I store in my DB, to it's string equivalent (xxx.xxx.xxx.xxx)? I would also need to convert it to host-byte order as well. Thanks, J ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Seeking documentation on writing own Tokenizer
Hello all, I am interested in writing my own tokenizer for sqlite3. I've gone through Google, as well as the sqlite documentation and unfortunately, I haven't found anything helpful. I am interested in writing my own tokenizer so that I could perform "partial string" matches in sqlite's full-text search (FTS3). For example, I would like to find the word 'some' in the string: '/path/to/some/file'. Can someone point me in the right direction on what I would need to do to implement my own Tokenizer? Thanks, Jon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Quick FTS3 question: partial matches
So while trying to find a solution to my problem of finding partial strings in several columns ( finding 'this' in 'HellothisIsATest' using MATCH '*this*' ), I found out that sqlite fts3 only supports prefix matching and that if I want to do partial string matching, I would be forced to use LIKE, or create my own tokenizer in order to index my terms the way I want. I wouldn't mind sacraficing size for performance since I do not have a size constraint for my project. My question is, has anyone already written a tokenizer that would do what I want? It seems as if this problem should have already been solved for me, and I really don't want to reinvent the wheel if it already has been done :) Thanks, Jon On Thu, Oct 9, 2008 at 9:51 PM, Jonathon <[EMAIL PROTECTED]> wrote: > Thanks for the reply. I was just curious if anyone has found a viable > workaround for this issue? Using the dreaded "Like" is a bit too slow for > what I need. > > Jon > > > On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]>wrote: > >> > I would like to look up partial strings across several columns using >> FTS3 >> > and MATCH. For example, if I have a column that has data, >> > 'helloThisIsATest'... and I do: >> > >> > select * from myTable where myTable match '*This*'; >> >> You can only use wildcards as a suffix - this is due to the nature of >> the indexes fts3 uses. >> >> I don't know of a possible workaround for this while still using fts3. >> I'd say that for this kind of request, you are condemned to use '... >> like "%This%". >> >> Alex. >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Quick FTS3 question: partial matches
Thanks for the reply. I was just curious if anyone has found a viable workaround for this issue? Using the dreaded "Like" is a bit too slow for what I need. Jon On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote: > > I would like to look up partial strings across several columns using FTS3 > > and MATCH. For example, if I have a column that has data, > > 'helloThisIsATest'... and I do: > > > > select * from myTable where myTable match '*This*'; > > You can only use wildcards as a suffix - this is due to the nature of > the indexes fts3 uses. > > I don't know of a possible workaround for this while still using fts3. > I'd say that for this kind of request, you are condemned to use '... > like "%This%". > > Alex. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Quick FTS3 question: partial matches
Hello all, I've looked through the archived mailing list and although I am sure my question is common, for some reason, I couldn't find an answer. I would like to look up partial strings across several columns using FTS3 and MATCH. For example, if I have a column that has data, 'helloThisIsATest'... and I do: select * from myTable where myTable match '*This*'; I would like to return the row above. However, I've tried this and it doesn't seem to work. It seems that prefix matching works though. So, if I do: select * from myTable where myTable match 'hello*'; that seems to return the right result. I am currently using FTS3 in version 3.6.2 and I have all the columns that I would like to index in the same virtual table. Thanks, Jon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How does SQLite store data?
John wrote: A TEXT string is stored at its actual length. You may declare a text column as 80 characters wide but you could store a string 32K long in that column. The 80 is stored by Sqlite but ignored. Stupid question. Does that mean that SQLite: * truncates the field at 80 characters? * only returns the first 80 characters in the field? * stores and returns the entire string? My impression was that it did that third option. [And that it didn't care what the data in that field was. It is up to the client program to verify the data.] xan jonathon - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Release / development timeline
D Richard Hipp wrote: > How much more announcing do you think we should do? The timeline page is great, for finding out when things were done. Changes is great for saying what is in the new versions, and when they were released How about a simple page that gives projected release date for upgrades? Something like Version 3.0.9 beta 10 November Version 3.0.9 final 20 November Version 3.0.10 beta 1 December Version 3.0.10 final 15 December xan jonathon -- How to have Hittite, Alibata, Orkhon, Ogham, Manchu, Meroïtic, Pahawh Hmong, Tengwar, Tsalagi, Hangul, Lepcha, and Nushu in the same document. http://oooauthors.org/groups/members/tutorials/
[sqlite] Release / development timeline
All: I've hunted around on sqlite.org, and the mailing list archives, [and googled] for a timeline of when the next version9s) of SqLite will be released. Does such a critter exist, and if so, where can I find it? xan jonathon -- How to have Hittite, Alibata, Orkhon, Ogham, Manchu, Meroïtic, Pahawh Hmong, Tengwar, Tsalagi, Hangul, Lepcha, and Nushu in the same document. http://oooauthors.org/groups/members/tutorials/
