gougou 的blog

编写vxworks的MakeFile

MakeFile文件内容如下

CPU = XXX1000 <<CPU类型

TOOL = gnu <<用gcc编译

ADDED_CFLAGS
= -g <<g表示生成用于Debug的目标文件

TARGET = target.o << 目标文件

发布Sqlite Developer 1.05 Beta1

更新情况,这个版本主要是追加了Unicode的完善支持,同时支持UTF8和UTF16的数据编辑,同时也支持创建Unicode表和字段名。下载地址:这里

发布Sqlite Developer1.02 Alpha2

1.02.75 Alpha2 (11/07/2005)

  • Fixed:Can not load ParserDll.dll on windows 2000 system.

1.02 Alpha2 (11/06/2005)

  • Fixed:[DBA] when edit table , grid shows xxx(1,2) datatype as xxx uncorrectly
  • Fixed:[Parser] can not parse create table sql with varchar, char, nchar, double ,numeric etc field type columns
  • New: [Export/Import] Import data from CSV when edit table data
  • Updated: [DBA] when pk's is autoincrement, automaticlly set Data Type to integer
  • Updated: [DBA] show Db Explorer's Db or table information at status bar
  • Updated:[GUI] Add Rows Affected Information to Log
  • New: [SQL Editor] Add Save SQL and Load SQL function to SQL Editor
  • Updated: [DBA] After Creating Table, automaticlly refresh Indexes
  • Updated:[SQL Editor] now Log was displayed order by date desc
  • New: [GUI] Add Windows Menu
  • New: [Install] Add a sample sqlite3 db (Sample.db3) to install package
  • New: [DBA] Add basic clipborad operation to Data Grid
  • New: [Option] Add SQL Editor Font Option to configure the Font and Font size.

最可怕的事

我用过最可怕的Unix类的操作系统是DEC的VMS操作系统,上面的命令给我感觉好像是咒语一样,每次敲的时候都要把参考手册翻出来,每次敲完命令都感觉恶心的要吐。

我用过的最可怕的编程语言是VB,因为没有真正的异常处理,所以你永远不会知道用VB写的程序为什么会突然当掉

调用DLL时犯了一个愚蠢的错误

昨天陈春华朋友给我写信,说他下载了我的Sqlite Developer,结果安装后无法运行,报无法加载ParserDLL.dll错误,我当时觉得很奇怪,因为我测试了一下在我的开发机器XP上没有问题,经询问才知道他的操作系统是Windows2000。今天我在Windows2000上重现了这个错误,仔细Review了一下代码,发现显式引用DLL的地方是这样写的。

const
//Fix can not load ParserDll.dll on windows 2000 system
ParserDll='ParserDll';

其中DLL扩展名没有写,这样的调用在XP系统上是正确的,但是在Windows2000系统上就会失败。

发布Sqlite Developer 0.97 Alpha1


0.97 Alpha1 (10/30/2005)

  • Fixed:[DBA] adjust too large string field display length in Data Grid
  • Fixed:[DBA] disable edit system table
  • Fixed: [DBA] make Data type names showed in Table Edit Grid same as the sqlite standard
  • New: [SQL Editor] Support view and edit string , blob field as Hex Value
  • New: [DBA] Advanced Index Management
  • New: [DBA] Add Old DDL Tab to Table, Trigger, Index and View Management UI.
  • Updated:[DBA] drop table, view and refresh the indexes and triggers at the same time
  • Updated: [Parser] when rollback automatically refresh the Db Explorer
  • Fixed: [SQL Editor] minor tweak DataType display in the auto complete window
  • Fixed:[DBA] now we can generate correct multi primary key create table sql
  • Fixed: [Query Builder] Query Builder now supports Views
  • Fixed: [DBA] Completely rewrite the Table Management and fixed lots of bugs.
  • Updated: [Install] Upgrade LiveUpdate

关于Delphi深度探索网站迁移通知


这两天我在CSDN上的网站空间域名解析有问题,所以我决定将原来的Delphi深度探索网站转移出来,今后大家可以用二级域名http://delphi.sharpplus.com进行访问

发布Sqlite Developer Preview 0.93


更新历史

  • Fixed:[Parser] some create SQL will not automaticlly add node to DB Explorer when executed successfully
  • Updated:Upgrade sqlite dll to 3.27.
  • Fixed: [Parser] Can not parse 'XXX' and "YYY" type table name
  • New: [DBA] support display and edit the temp table, view,trigger
  • New: [GUI] Add two new filter(All non-system and non-temporary Objects, All non-temporary Objects)
  • Updated:[GUI] display sqlite3 DLL version in About Dialog
  • Updated: [GUI] Show different icons with tempoary and system table, view, trigger, index.
  • Updated: [GUI] Add some icon to menuitem
  • Updated: [GUI] Minor tweak of options menu
  • Fixed:[DBA] Execute sql does not hide the result tab
  • New: [DBA] Advanced Trigger Management
  • New: [DBA] Add advanced view management

不能在Parser部分对Rule使用~操作符号

不能在Parser部分对Rule使用~操作符号

对于Parser Rule,只能使用+, *, ?

但是可以对Lexer Rule使用~操作符号

antlr的缺点之一

出于性能的考虑,Antlr没有实现完全的LL(K)解析,而是用了线性的LL(K),但是线性LLK会产生很多的不确定性。经常导致你需要将自然的Parser Rule改写为不自然的形式。

不过据说Antlr 3将提供完全的LL(K)实现,不过从目前的进度来看,感觉要到2007年能推出就不错了:(

同步内容