Re: [sqlite] Regarding CoC

[dmp]

Code Of Conduct, misplaced disposition on the individuals of
an organization rather than the results of their work on
intent.

I have had a simple statement with my open source software
downloads for years.

"Dandy Made Productions would like to assure individuals that
 any applications downloaded from this site are free from any
 malicious code as so created. Great pride is taken in trying
 to create ethical software that does not knowingly modify, or
 change files or a system's configuration beyond the user's
 request. In addition no software downloaded from this site
 performs any type of monitoring or reporting on the user's
 behavior in use of said application. Every reasonable attempt
 is made to maintain the integrity of the downloaded software
 packages at this site."

Dana M. Proctor

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

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

[dmp]

> I have a bunch of hyperlinks in an SQLite database, and need to read each
> page for validation before deleting the record.
> To make it easier, the DB manager should launch the default web browser
when
> I double click on a column that contains a hyperlink.

> Before I build a GUI, is there a Windows SQLite database manager that
can do
> this?

Hello,

Though my application does not do what you desire it is a framework
for plugins. The GUI, database connection stuff and a tutorial for
creating plugins is available as open source. Seems a lot of work
to create a new GUI for the purpose stated.

The other response on creating a HTML file seems quicker.

http://ajqvue.com/documentation.html
http://ajqvue.com/docs/Plugins/PluginBasics/Ajqvue_PluginBasics.html
http://ajqvue.com/docs/Plugins/PluginAdvanced/Ajqvue_PluginAdvanced.html

danap.

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

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

[dmp]

>> On Oct 9, 2018, at 7:19 PM, Warren Young  wrote:
>>
>> The arguments about mailing lists vs forums have all been had.

> It’s not clear why this entire conversation is presented in such stark
terms: LIST
> *OR* FORUM. Puzzling.
>
> If this is all driven by DRH edict that “all things shall run on fossil”
, then you
> know what to do: list2forum + forum2list
>
> There is no problem, if you don’t dogmatically insist on making it one.

Thank you. So far I have seen mostly only one insisted advocate
for a forum with no comment seems from the actually owner of this
list. If the owner wishes to transition to only a forum then please
just state it and get on with it; your idea seems better though.
Maybe then this thread will die.

danap.

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

Re: [sqlite] Ajqvue v2.10 Released

[dmp]

> Looks good.
>
> Would pronouncing ajqvue -- achoo? -- send Mr. Mxyzptlk back to the 5th
> dimension for 90 days?
> Ned

Perhaps if it was said three times while clicking your heels together.

Ajqvue - A Java Query Vue

danap.

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

[sqlite] Ajqvue v2.10 Released

[dmp]

Ajqvue Version 2.10 Released

The Ajqvue project is pleased to release v2.10 to the public. The release
is minor in nature with a new feature to allow opening local file databases
in the Login Frame via a file chooser. Work was also completed to support
the DB_to_FileMemoryDB plugin, package utilities.db, and update the
QueryBuilder plugin.

Dana M. Proctor
Ajqvue Project Manager
http://ajqvue.com
https://github.com/danap/ajqvue


Ajqvue provides an easy to use Java based user interface front-end
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.

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

Re: [sqlite] DB To DB Transfer Time

[dmp]

> Why aren't you measuring the time spent only in the SQLite writing thread?
>
> That would eliminate the overhead from the read-thread(s) and the queue in
> the middle,
> measuring only work by SQLite, instead of including the *waiting* for work
> in the queue.
>
> I wrote a similarly "piped" ETL not too long ago, and I output overall
> "wall" time of course,
> but also time spent reading, time spent writing, but important times when
> reader/writer threads
> were "stalled", because the pipe is full/empty (respectively). --DD

Hello,

Too the question, because it is unnecessary coding, time wasted. If I have
an idea already of the goal and with the timing overall can determine where
to focus the effort it is more efficient use of my time. The monitoring of
the pipe, one coding action, already gives me an idea of when read/writer
are stalled. So no need in to have timing for those.

Yesterday I put the threads on equal footing and derived the following
result which are close to my goal.

50,000 rows queried from a networked MariaDB, fields (integer, real, text,
blob).

SQLite - 114.838 seconds
H2 - 115.868 seconds
Derby - 136.984 seconds
HSQL - 1291.808 seconds

Mind you that the plugin needs to use any query to any of the supported
databases, MariaDB, Oracle, PostgreSQL, etc. and derive a comparable
schema table from the query to create a file/memory database.

Looks like SQLite or H2 are the most likely candidates at this time.

All of this is a lot of variables that effect timing. Focusing on only
the data transfer timing, above, or writes to the sink db is only part
of the timing, though probably the place to derive the most benefit.

danap.

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

Re: [sqlite] DB To DB Transfer Time

[dmp]

>> On Sep 25, 2018, at 11:14 AM, dmp  wrote:
>>
>> The result for the 50K file db test of SQLite was 370.184
>> seconds. Is this a reasonable transfer speed, given the
>> conditions noted?

> You haven't specified how much of that time was spent in SQLite. For all
we know,
> 370 seconds was spent in MariaDB and your own code, and it only took
.184 sec for
> SQLite to insert the rows :)

> Try running your code with a profiler. Or at least wrap some quick &
dirty timing
> code around your functions that call SQLite.

> Also, make sure to insert as many rows as possible within a transaction.
Committing
> a transaction in SQLite is quite expensive due to filesystem flushing.

> —Jens


Hello,

The DB to DB code is a Java plugin for my application. It takes
a query to the current database, converts that into a schema,
creates a new table in the selected sink database of a comparable
schema, then begins transferring data.

The data transfer is setup with two threads, the source database
thread loading data and the sink database thread inserting via
prepared statements in a batch mode. The threads are connected
via an ArrayBlockingQueue pipe. I log the pipe capacity as the
process takes place.

The timing given takes place at the beginning of the transfer
process and stops when completed, threads join.

Now from the users of the forum, I did some testing to establish
a reference transfer time. After some thought I realized I could
get that number by just performing a direct file transfer of
the created SQLite database file from the MariaDB server to the
client machine. Results 54 seconds.

Upon further testing, increasing the pipe size, 250 to 1000.
I was able to get the time for the SQLite test to 164.721 sec.
Average pipe capacity, 85 objects. That tells me that I could
do better perhaps using two loading threads. I already suspected
the loading thread filler to be slower and therefore had coded
it with an increased priority of one.

The testing so far shows SQLite comparable to the other tested
memory databases. SQLite beat out all but one with a file
database. One of the databases did miserable with the pipe
capacity close to saturated and a time of 1374.614 sec.

Testing:
Transfer 50,000 rows, (Integer, Real, 0-10k Text, 0-10k blob)
Resulting SQLite file database size: 404Mb.

Updated SQLite Log Database:
https://github.com/danap/db_to_filememorydb/blob/master/docs/dblog/db_To_db_Parameters-log.db

danap.

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

Re: [sqlite] DB To DB Transfer Time

[dmp]

Hello,

Thank you for the responses, Stephen and Dominique.

I was generally looking for an idea if the transaction
time seemed reasonable, given a low end MariaDB server,
standard 100Mb LAN, and mid range user processing desktop
machine.

I realize that the question as answered is; Hard to say!
My initial reaction was slow, not good enough.

The log db, was created because of the parameters involved
in evaluating the transfer had many factors. This allowed
a way to track changes in those parameters with results.
It also gives additional insight to the testing hardware.
SQLite was one of four local file/memory databases evaluated.

https://github.com/danap/db_to_filememorydb/blob/master/docs/dblog/db_To_db_Parameters-log.db

Again thanks for responses. The idea of using transfers
with the SQLite built in tools, .dump, .backup if setup
with a similar scenario can provide some reference point
to answer my question.

danap.

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

[sqlite] DB To DB Transfer Time

[dmp]

Hello,

I have created a database to database transfer plugin for
my application. The plugin is functional and I have
collected a log of testing results stored in a SQLite db.
The links below are of the database and definition of
parameters fields. The main exception, dbTypeMemory,
meaning memory or file db.

https://github.com/danap/db_to_filememorydb/blob/master/docs/dblog/db_To_db_Parameters-log.db
https://github.com/danap/db_to_filememorydb/blob/master/lib/plugins/DB_To_FileMemoryDB/transfer-param.config

Testing was done with a 50K entry MariaDB table on a low
end local network machine. Four fields in the table, Integer,
Double, Text, and Blob. Text and Blob fields of arbitrary
length to 10K.

Resulting file database sizes for all 50K rows were in the
range of 390MB to 1.83GB.

The application is Java based and uses JDBCs.

The result for the 50K file db test of SQLite was 370.184
seconds. Is this a reasonable transfer speed, given the
conditions noted?

danap.

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

Re: [sqlite] Best practices for forward conversion of database formats?

[dmp]

Randall wrote:
~
~
> Any application that involves a "persistent" database, i.e., one where
the data is
> long-lived and expected to exist and evolve over time, sooner or later
has the issue
> of moving customers from a V1 database to a V2 database.  Obviously at
least one
> technical issue (there are probably others) is how to convert existing
data from one
> DB format to another, given some arbitrary set of changes in the
database schema in
> the interim.

> Are there accepted or best practices in the industry for handling this
in general,
> or with SQLite in particular?  Can anyone who has implemented this make
useful
> suggestions?  Or are there published resources I am missing?

Hello,

I should suppose pretense with I'm wholly ignorant to such a process, but
even
has such may have some wisdom. The only reason I'm replying because I have
been
working on I guess an ORM, data converter it seems.

One, it seems data is best preserved in a standard raw format such as CSV.
SQL
statements from one database do not translate to another databases well and
perhaps of the same database v1 to v2.

Two, with changes to schema it seems the simple way to go would be export
data
in a query fashion, to match the new schema. Leave out columns not needed and
a default for new.

Three, this in hindsight, but data should be always be in it simplest form as
possible, Integer, Char, etc. The most intolerant data is temporal
information.
For these ALWAYS use a SQL or a common appropriate standard.

danap.

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

Re: [sqlite] Time Precision

[dmp]

Keith Medcalf wrote:
> Are you running Windows or Unix?  I am sending this to you as I was just
looking
> into this again and although SQLite maintains time internally with a
millisecond
> precision, the API used on Windows to read the time is limited by the Clock
> Resolution (usually about 16.5 ms).  If you are using Windows 8 or
later, then you
> can edit the SQLite3 amalgamation code (and/or the winfvs source) and
use the
> GetSystemTimePreciseAsFileTime call rather than the
GetSystemTimeAsFileTime call
> (around line 40866 in the aamalgamation code)

The time precision issue revolved around the lack of date, time, etc.
types in SQLite
and my Java application GUI using a JDBC. The java.sql.Time class is
defined as:

Time(long time)
Constructs a Time object using a milliseconds time value.

A JDBC setTime() or getTime() expects this long integer. Most databases I
would
assume stores a time type as a long intger with precision of milliseconds
even
though the ISO-8601 standard defines precsion to seconds.

The conversions using the datetime functions with SQLite as I was using them
did not give me milliseconds precsion. With a greater understanding of those
functions I was able to create the precision needed.

Seems it was one of the of the recommended solutions provided by you that
solved
my issues.

danap.

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

Re: [sqlite] The upcoming alter table rename column

[dmp]

Still doesn't work when saving directly to file. Nice
though. Modified version follows. Thanks.

danap.

Fixes/Adds:

1. Header comment added --.
2. Added drop IF EXISTS.
3. Each CREATE VIEW added space after AS.
4. Placed end of statement semicolon directly after parenthesis.
5. Has only \n for end of lines.


--  Schema Info Views
--
-- This is a set of views that supply queryable Schema information for
-- SQLite DBs in
-- table format.
--

DROP VIEW IF EXISTS SysIndexColumns;
DROP VIEW IF EXISTS SysIndexes;
DROP VIEW IF EXISTS SysColumns;
DROP VIEW IF EXISTS SysObjects;

CREATE VIEW SysObjects AS
SELECT ObjectType COLLATE NOCASE, ObjectName COLLATE NOCASE
   FROM (SELECT type AS ObjectType, name AS ObjectName
   FROM sqlite_master
  WHERE type IN ('table', 'view', 'index')
);

CREATE VIEW SysColumns AS
SELECT ObjectType COLLATE NOCASE, ObjectName COLLATE NOCASE, ColumnID
COLLATE NOCASE,
ColumnName COLLATE NOCASE, Type COLLATE NOCASE, Affinity COLLATE
NOCASE,
IsNotNull, DefaultValue, IsPrimaryKey
   FROM (SELECT ObjectType, ObjectName, cid AS ColumnID, name AS
ColumnName, type AS Type,
CASE
  WHEN trim(type) = '' THEN 'Blob'
  WHEN instr(UPPER(type),'INT' )>0 THEN 'Integer'
  WHEN instr(UPPER(type),'CLOB')>0 THEN 'Text'
  WHEN instr(UPPER(type),'CHAR')>0 THEN 'Text'
  WHEN instr(UPPER(type),'TEXT')>0 THEN 'Text'
  WHEN instr(UPPER(type),'BLOB')>0 THEN 'Blob'
  WHEN instr(UPPER(type),'REAL')>0 THEN 'Real'
  WHEN instr(UPPER(type),'FLOA')>0 THEN 'Real'
  WHEN instr(UPPER(type),'DOUB')>0 THEN 'Real'
  ELSE 'Numeric'
END AS Affinity,
"notnull" AS IsNotNull, dflt_value as DefaultValue, pk
AS IsPrimaryKey
   FROM SysObjects
   JOIN pragma_table_info(ObjectName)
);

CREATE VIEW SysIndexes AS
SELECT ObjectType COLLATE NOCASE, ObjectName COLLATE NOCASE, IndexName
COLLATE NOCASE,
IndexID, IsUnique COLLATE NOCASE, IndexOrigin COLLATE NOCASE,
isPartialIndex
   FROM (SELECT ObjectType,ObjectName,name AS IndexName, seq AS IndexID,
"unique" AS isUnique, origin AS IndexOrigin, partial AS
isPartialIndex
   FROM SysObjects
   JOIN pragma_index_list(ObjectName)
);

CREATE VIEW SysIndexColumns AS
SELECT ObjectType COLLATE NOCASE, ObjectName COLLATE NOCASE, IndexName
COLLATE NOCASE,
IndexColumnSequence, ColumnID, ColumnName COLLATE NOCASE,
isDescendingOrder, Collation, isPartOfKey
   FROM (SELECT ObjectType, ObjectName, IndexName, seqno AS
IndexColumnSequence, cid AS ColumnID,
name AS ColumnName, "desc" AS isDescendingOrder, coll AS
Collation, key AS isPartOfKey
   FROM SysIndexes
   JOIN pragma_index_xinfo(IndexName)
);

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

[sqlite] Ajqvue Version 2.0 Released

[dmp]

The Ajqvue project is pleased to release v2.0 to the public. The release
is a major maintenance, cleanup, and consolidation of the code base. In
part most of the work was driven by a DB_to_FileMemoryDB plugin and insuring
a more robust handling of SQLite affinity. The sqlite-jdbc library has again
been included with the application. All libraries have been updated. The
plugin DataCharts included with Ajqvue has been updated with JFreeChart,
1.5.0.

Dana M. Proctor
Ajqvue Project Manager
http://ajqvue.com
https://github.com/danap/ajqvue


Ajqvue provides an easy to use Java based user interface front-end
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.

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

Re: [sqlite] SQLite .dump

[dmp]

Simon Slavin wrote:
> I'm sorry, but I don't see a question in your post.

As intended. It was just a statement based on observation,
with regard to SQLite .dump, my GUI dump, and other database
dump outputs. MySQL also uses a short version without
specifying column names, but does quotes identifiers.

Warren Young wrote:
> and using the database's
> identifier quoting character.

> It does that at need already:

> sqlite> create table "x y" ("a b" INTEGER);
> sqlite> .dump
> PRAGMA foreign_keys=OFF;
> BEGIN TRANSACTION;
> CREATE TABLE IF NOT EXISTS "x y" ("a b" INTEGER);
> COMMIT;

Seems only when the initial dll specified.

sqlite> create table x (a INTEGER);
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE x (a INTEGER);
COMMIT;

There is no intention to indicate a bug, or other aspect
about a deficiency in SQLite .dump.

The reason my tool provides columns is because the
dump is made to allow users to selectively save data
from only the specified columns.

The reason I always quote identifiers, is because people
do stuff like this for names, "keY_cOlumn2".

If that was not quoted in dml then it might be interpreted
as KEY_COLUMN2 for example in some databases, and then throw
an error.

NO SUCH COLUMN.

danap.

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

[sqlite] SQLite .dump

[dmp]

Hello,

Recently in testing my GUI tool I made a comparison from the
tool's dump and SQLite's command line .dump tool.

Seems .dump uses a short output of skipping the column names.
According to some of my research for various databases I use
one of these as options for SQL dump output:

http://ajqvue.com/docs/Manual/Ajqvue_Manual.html#Preferences_Data_Export_SQL
Preferences Data Export SQL

Always specifying the column names list and using the database's
identifier quoting character.

danap.

===
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE datatypes (data_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
int_type INTEGER, real_type REAL, text_type TEXT,
blob_type BLOB, date_type DATE, time_type TIME,
datetime_type DATETIME, timestamp_type TIMESTAMP);

INSERT INTO datatypes VALUES(1,100,200.18864,'some text',
 X'6162630a',153051120,68715000,1530343358000,
 1530559371079);

===
GUI tool:
--
-- Dumping data for table "datatypes"
--

INSERT INTO "datatypes" ("data_type_id", "int_type", "real_type",
"text_type",
 "blob_type", "date_type", "time_type",
"datetime_type",
 "timestamp_type") VALUES(1, 100, 200.2, 'some text',
 x'6162630a', 153051120, 68715000, 1530343358000,
 1530559371079);

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

[sqlite] (no subject)

[dmp]

On 7/12/18, danap wrote:
>> I use a dump
>> in my interface which I used with diff to compare changes in my
>> personal expense database. This was to insure changes introduced in work
>> on the interface were not screwing things up. Very helpful to insure
>> your not introducing bugs.

D. Richard Hipp wrote:
> I am glad that has been working for you.  But there is a caveat:  The
> ".dump" format can (and does) change slightly from one release of
> SQLite to the next.  So you are welcomed to continue using ".dump"
> this way, but just be careful that you do not compare the .dump output
> from two different versions of SQLite.

Well, sorry Mr. Hipp, but the dump was from my own SQLite GUI. So what
I was doing is insuring some coding changes to the GUI's dump had not
changed anything, by comparing to prior dumps of data with the same
tool. So I was really doing exactly what you caution about to debug
between versions.

Idea being, dump ASCII data, compare over time with some kind of diff
tool to see changes. So to user's question, be sure to use same version
of the dump tool as you indicate.

danap.

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

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

[dmp]

Randall wrote:

> My wishlist is:
> (o) Allow humans to view the contents of a DB without custom tools.

If what is meant here is a generic tool that opens/views any particular
file format, db context here, then there are tools including
the generic db gui that I have been working on for years.

> (o) Have a way to see what has changed between V1 and V2 of a database,
> e.g., for a "change review."
> (o) Have a way to merge two independent sets of database changes into
> a single result in an understandable way.

This has already been answered, .dump diff and sqldiff. I use a dump
in my interface which I used with diff to compare changes in my
personal expense database. This was to insure changes introduced in work
on the interface were not screwing things up. Very helpful to insure
your not introducing bugs.

> (o) Have a way to make changes (update, insert, delete) to the DB data
  in a  pinch without specialized tools.

My generic db gui will do all these. Once more it really is a plugin
framework so it is very easy to introduce your own code to extend its
behavior.

Seems parts of the wishlist could be provided more effectly by client/server
db rather than SQLite. My personal general expenses database is not
SQLite, but a client/server db. Just an old box back in the corner. Why,
because I use the same db server with my dad's, in his 90s, expenses which
we both can add, edit, search, review, and aggregate accounts at the
end of the year.

danap.

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

[sqlite] Subject: Re: Date Search

[dmp]

Keith wrote:
> Correct.
> You have stored integer Unix Epoch timestamps.  You cannot do "string"
> searches on integers (at least not ones like what you have asked for,
> which involves conversion of an integer representing a Unix Epoch offset
> to an ISO-8601 string, not to an ordinary "string representation of
> the integer".
>
> There is no "DATE" type in SQLite3 -- only INTEGER, REAL, TEXT, and
> BLOB -- and no magical conversion of integers into ISO-8601 strings
> or v/v.
> ~
> ~
> If you want your date_type integer to be converted to a date string,
> you need to use the function for converting integer unix epoch offsets
> into ISO-8601 date strings:
>
> SELECT id, date_type FROM date_types WHERE date(date_type, 'unixepoch')
> LIKE '2018-%-%';
>
> The usual caveats apply for knowing what your timezone is and handling
> such conversions appropriately for your platform (OS).

WHERE date(date_type, 'unixepoch') seems the way to go and will now focus
on that as a solution.

danap.

David Raymond wrote:
> You have to make everything the same type, either numeric or text.
> ~
> ~

R Smith:
> Why not add to the table both the converted Integer date[i.e:
> strftime('%s', '2017-01-01')] AND the ISO8601 date [i.e: '2017-01-01
> 00:00:00']?
>
> That way you can reference either, use any of them for calculations, and
> filter/lookup by whichever one suits the occasion best.
> ~
> ~

Thanks for the repies all. David and R. that would be nice, but the context
here is with a GUI for users so I do not get to define db schema.

I do actually have a test data types table that is loaded with Date data
with both Integer and Text content. Along with also Time, Datetime,
and Timestamp.

Yes I know all those could be Real or a Blob, but I'm trying to pick the
most likely content that users would store for those types. Integer and
Text seem the most appropriate.

danap.

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

Re: [sqlite] Time Precision

[dmp]

danap wrote:
> SELECT CAST((SELECT (julianday('now', 'localtime') -
> julianday('1970-01-01'))*24*60*60*1000) AS INTEGER);

Keith wrote:
> Are you sure you want to be mixing up timezones?
>
> julianday('1970-01-01') returns the julianday timestamp
> for 1970-01-01 00:00:00 GMT julianday('now', 'localtime')
> returns the julianday timestamp for 'now' in your
> current timezone.

No. You are correct and after my initial posting reply, above, fixed
the Time Precision to your initial suggested example, 'now', only in
the code.

danap.

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

[sqlite] Date Search

[dmp]

Given:

SELECT STRFTIME('%s', '2018-01-01');
1514764800
SELECT STRFTIME('%s', '2017-01-01');
1483228800

CREATE TABLE date_types(
  id INTEGER PRIMARY KEY,
  date_type DATE
);

INSERT INTO "date_types" ("id", "date_type") VALUES(1, 1514764800);
INSERT INTO "date_types" ("id", "date_type") VALUES(2, 1483228800);

date_type: Affinity now Integer.

This does not seem to be possible, without some type of conversion to a
Integer(s)
value(s) then searching in a numeric range for the given TEXT date?

SELECT "id", "date_type" FROM "date_types" WHERE "date_type" LIKE '2018-%-%';

danap.

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

Re: [sqlite] Time Precision

[dmp]

> Igor wrote:
> select (julianday('now') - julianday('1970-01-01'))*24*60*60*1000

> Keith wrote:
> select (julianday() - 2440587.5) * 86400.0

Both of these got me on my way, Igor's a little more clearer. I'll
doing a little more checking to insure the solution below is correct,
but seems good. Thanks.

danap.

Solution:

SELECT CAST(
(SELECT (julianday('now', 'localtime') -
julianday('1970-01-01'))*24*60*60*1000)
AS INTEGER);

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

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

[dmp]

> Mailing lists are now back on-line and once again accepting
> subscriptions.  I have implemented measures to block the subscription
> robots and to better log subscription activity to better detect future
> mischief.

> I consider this to be a stop-gap measure that will buy me some time
> to implement and test a better log-term solution. .

> D. Richard Hipp
> d...@sqlite.org

As a comment, again with past post with regard to Mailing List.

This mailing list is a very informative, simple, and a conveniant
method to disperse information in a bulk format. A change to a web
interface, (forum, other), that requires a login each day is most
likely going to push me away.

Hope a fix can be accomplished.

danap.

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

Re: [sqlite] Subject: Re: SQL Date Import

[dmp]

> SQLite doesn't have a DATE type.  You can store dates in a SQLite
> database as text, or integers or floating point numbers (e.g. "20180602",
> a number of days, a number of seconds).  But when you ask for a value,
> that's what you'll get back.  Any interpretation of that value as a
> date is up to you or your software.

> Simon.

That is the real crux of the situation, I have a handle on how to display
DATEs whether they are NUMERIC or TEXT. Users really gather no meaning
from temporal values as numbers.

The real issue I suppose after some thought is the export/import of a
DATE, TIME, TIMESTAMP. Most Databases for both SQL, INSERT example,
and CSV is done with TEXT. Example being standard SQL DATE, -MM-DD.

I think that the case is to preserve the users data in the type they
have chosen for SQL export, have to test each entry for NUMERIC or TEXT.

The import of the SQL INSERT statements will return the database entries
to the same data. I have no control on those since they are passed
directly to SQLite.

CSV export will be TEXT, since that is the most likely way a spreadsheet
will recognize the data.

I will have to test probably import of CSV for NUMERIC or TEXT and not
just assume TEXT. A determination can be made of the typeof() for the
DATE field as NUMERIC or TEXT then transition the data accordingly if
need be.

danap.

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

[sqlite] Subject: Re: SQL Date Import

[dmp]

Keith Medcalf wrote:
> Yes, and the database will store the data as entered/bound if it
> cannot be converted to the requested storage type (column affinity).

Yes, that was my understanding and there-lies the problem. A column
of type DATE, TIME, or TIMESTAMP that may have NUMERIC and TEXT data.

> This is VERY IMPORTANT for you to understand fully and completely
> including all the rules for storage class and affinity conversions
> and how they are determined.  I would recommend that you SAY what
> you mean, and not confuse things (including yourself) by using
> "prayerful" data type declarations that are NOT in the proper set
> (INTEGER / REAL / NUMERIC / TEXT / BLOB).

Unfortunately as a middle man between a database designer and a user,
who maybe the table creator, I do not get to decide what they define
and what they put in a table, a combination of types for Date perhaps,
or maybe just TEXT. The example given INSERT could give you the former.

By the way, most databases give exactly that INSERT when dumping data
for DATE, TIME, TIMESTAMP, etc., text. I'm not advocating a preferred
type for storage here.

Thank you for the response. I think I will go ahead and install SQLite
on a machine so that I can experiment some more directly via the command
line, before deciding on an action to take on the issues I'm having.

danap.

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

[sqlite] SQL Date Import

[dmp]

Currently I do not have SQLite setup to run on its own on a computer.
I figured the answer to my question would be faster if it was posed
to this list.

Given:

CREATE TABLE exdate (
  id INTEGER,
  mydate DATE NOT NULL,
  PRIMARY KEY (id)
);

Once a number, numeric, is stored. Can a command line import
in standard SQL for DATEs be done, if at all?

INSERT INTO exdate (id, mydate) VALUES(1, '2018-06-01');

danap.

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

Re: [sqlite] Size of the SQLite library

[dmp]

1. Define in documentation as < 1Mb. (Don't have to visit again.)

2. Continue to strive to keep in the 0.5-1MB range.

3. Add some information on building a MINIMUM size for those
   concerned that is relatively easy to accomplish without
   a lot of expertise if possible.

danap.

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

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

[dmp]

Scott Robinson wrote:

> What version of SQLite are you using for this? I just did the
> following and do not see the string quoted values you are describing:

I'm sorry, the example given was just the current one I was
using to test the fix. In general I found the application was
quoting all Numbers and I was WRONG about the meta data stored
in the db file. It seems in almost all cases Sqlite is doing
a very good job of storing meta data I think.

Too clarify my application is coded in Java and is using a JDBC.

The example belows indicates that even when a mistake is made for
instance in declaring a type of TINYIN, the SQL type stored or
derived from the JDBC for the meta data is, 4, INTEGER. Good
guess!

CREATE TABLE exnumeric(
weight TINYNT NOT NULL,
speed DOUBLE);

NameJava Class   SQLTypeSQL Type Name
weight  java.lang.Object4   TINYNT
speed   java.lang.Object8   DOUBLE

In general if a table type is declared outside the defined SQL
types it still, for example (weight, kilograms), is defined as
TEXT it seems.

The issue I was having had to do with keying off only the Java
Class which in all cases is java.lang.Object. Most other databases
return for example the speed column, as java.lang.Double
from a Java ResultSetMetaData.

danap.

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

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

[dmp]

Suppose outside the subject of this thread, but in the document.


Sustainability factors

Self-documentation:
"The database format incorporates technical and structural metadata
 needed to interpret and manipulate the data itself. For example,
 a database file will include the CREATE TABLE declarations that
 define tables and columns. To the extent that meaningful names are
 used for tables and columns, the nature and context of the data
 may be recorded. However, there is no explicit structure within
 the file for storing fuller descriptive and contextual metadata.
 Nor is there a capability to embed in the file a metadata object
 conforming to a schema outside the SQLite specification."


This constantly bites me. This morning I had to generate a fix
to correct context of exported SQL statements for a dump of data.

The numeric values were being quoted as strings so therefore when
imported back in, they would have been treated as strings instead of
numbers.

DROP TABLE IF EXISTS mySinkDBTable;
CREATE TABLE mySinkDBTable (
key_id1 INTEGER UNSIGNED NOT NULL,
key_id2 INTEGER UNSIGNED NOT NULL,
text VARCHAR
);

--
-- Dumping data for table mySinkDBTable
--

INSERT INTO mySinkDBTable (key_id1, key_id2, text) VALUES('1', '8', '51');
Corrected:
INSERT INTO mySinkDBTable (key_id1, key_id2, text) VALUES(1, 8, '51');

Since the user is allowed to store the metadata for the table
types, example above, it is difficult for tools too determine
the proper processing for the data. I understand the flexibility,
and perhaps typeof() would solve most of my issues, but it would
be nice to have metadata field type stored as INTEGER, REAL,
NONE, TEXT, or BLOB.

danap.

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

Re: [sqlite] sqlite-users Digest, Vol 125, Issue 28

[dmp]

> I tried to create a shareable in-memory database as per the documentation
>  provided on SQLite  Site. But I end up finding the solution to the
> problem.
>
> *Here is my code in C#*:
>
>
> var connectionString = "Data
> Source=sharedmemdb;Mode=Memory;Cache=Shared";
>
>
> using (var connection1 = new SQLiteConnection(connectionString)) {
> connection1.Open();

I know nothing of C# or the argument requirements for SQLiteConnection(),
but did you try:

var connectionString = "Data Source=:memory:;Mode=Memory;Cache=Shared";

or

var connectionString = "Data Source=file::memory:;Mode=Memory;Cache=Shared";

per the documentation.

danap.

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

Re: [sqlite] How to Handle BigInt

[dmp]

> Also note that if you store your numbers as strings, indexes on those
> values will order them as strings.  In other words, searching and sorting
> will work incorrectly.

> It should be possible to get your numbers from a Java numeric variable to
> a database numeric value without passing them through a string at any
> point.  And, of course, back out of the database into a numeric variable.
> If your database library does not allow this, you have a serious problem.
>
>
> As a solution purely about SQLite, SQLite has a "black box" type of BLOB.
> BLOB is used to store bytes, without putting any interpretation on those
> bytes.  Although technically you can search and sort BLOBs, it's probably
> a sign of faulty thinking.  If I was trying to store something in a
> database which I didn't want interpreted in any way, I'd use a BLOB.
>
> Simon.

Hello,

Since the purpose of the code is to replicate a database SQL query
to a memory/file SQLite database then it seems appropriate to maintain
the integrity of the fields as closely as possible.

I shall look at treating the fields for numbers as a generic numeric
variable in Java. The original code derived from obtaining input from
a user, so therefore strings, and parsing to check for valid input
before storing.

PostgreSQL max/min BigInt are fitting in fine as SQLite's Integer.

Thank you for comments.

danap.

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

Re: [sqlite] How to Handle BigInt

[dmp]

> SQLite integers are all 64 bit - I don't about postgress, so unless
> postgress allows integers bigger than 64 bit, and you use them, you should
> be OK with your table definitions above.

> Paul

Hello,

That really provides insight to the real issue, I was having and so therefore
the question.

Since I'm using Java and JDBC I was retrieving numeric fields in PostgreSQL
with getString(), handles all, then using Integer.parseInt(stringValue) for
BigInts in storing to SQLite.

There lies the problem since BigInt values were exceeding the range of
Java Integer. My original solution was to store these as strings, will now
just use Long.parseLong(stringValue) and store has SQLite Integers
properly.

danap.

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

[sqlite] How to Handle BigInt

[dmp]

Hello,

Given a conversion from a database table that contains BigInt, long,
field from PostgreSQL to a SQLite similar table.

CREATE TABLE postgresqltypes (
  data_type_id serial,
  bigInt_type bigint)

CREATE TABLE sqlitetypes (
  data_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
  int_type INTEGER)

How to store, for values outside range for Integer,
String or Real?

danap.

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

Re: [sqlite] JDBC driver experience

[dmp]

> Are you using SQLite with JDBC?  If so, can you please answer a few
> questions below?

> You can post on this mailing list or send your reply directly to me.

1. Which JDBC are you using?

Current Xerial SQLite JDBC
https://github.com/xerial/sqlite-jdbc

Others that I have tried are a Werner-JDBC and Zentus-JDBC. The
Xerial if I remember was derived from one of those. The most
current functional up to date is I believe Xerial.

2. For how long have you been using it?

My Java project, Ajqvue, began support for SQLite in 2014 and
that is when most of the research was done on finding a decent
functional JDBC.

3. What issues you had with this driver?

Ajqvue is a generic GUI for connecting to several databases to
include SQLite. That means I need to connect to a database and
display any table data and provide functionality for import/export
of data. The application also comes with plotting, analysis,
and profiling capabilities.

SQLite was one of the easiest database to support because it
only has four data types. Most of all my problems with JDBCs
have arrive with data types, mainly temporal ones, Date, Time,
and the dreaded Timestamp. Currently that is one of the main
issues I have with the current Xerial JDBC.

https://github.com/danap/ajqvue/issues/2

See:

https://github.com/xerial/sqlite-jdbc/issues
https://github.com/xerial/sqlite-jdbc/issues/88

Overall:
  * Does anyone respond to issues? :) Thats about it!

4. What advise do you have for avoiding problems in this driver?

Since my main experience with a driver is through a user GUI
and I'm not using in production I'm sure others could answer
this better. Currently I trying to complete a plugin for Ajqvue
that transfers data from others databases to SQLite. So I'm
sure I may come across some other discrepancies.

https://github.com/danap/db_to_filememorydb

From my perspective your database table schemas should be
based on the SQLite four data types, NO others. Of course
since I was instructed in structured programmer, I really
don't think a specified data type, can be any desired object
and the database really doesn't care. It really confuses me!

danap.

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

Re: [sqlite] Free tool to visualize a schema?

[dmp]

> Hi,
> I think the visualization of a schema helps to develop a sqlite database.
>
> I am searching for a free software, like SchemaCrawler.
> It is good, but can't show CONSTRAINT and FOREIGN KEY names in the
> diagram.
>
> I just tried out the Sqleton but it can't be start on my system so far.
> Do you uses such a free tool?
>
> Best, Pali

Hello Pali,

Ajqvue,
A free open source database access tool.
http://ajqvue.com/

It has a visual QueryBuilder, plugin.
http://ajqvue.com/plugins.html
http://ajqvue.com/images/screenshots/querybuilder/querybuilder_diagram.html

The application is in Java, and uses a JDBC to access a SQLite
database, file. At this time I no longer bundle a JDBC, with the
project for SQLite. One can be found though at:

https://github.com/xerial/sqlite-jdbc

Place its Jar in your jre/lib/ext folder and Ajqvue will have
access to it. I have not tried this current library and usually
build my own.

Dana M. Proctor
Ajquve Project Manager

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

unsubscribe

[dmp]

unsubscribe


-
To unsubscribe e-mail: user-unsubscr...@spark.apache.org

Mail List Daily Archive

[dmp]

Hello,

Upon joining this mailing list I did not receive it seems a
link to configure options. Is there a way to set for a daily
archive of correspondences like mailman.


-
To unsubscribe e-mail: user-unsubscr...@spark.apache.org

Re: [sqlite] Many ML emails going to GMail's SPAM

[dmp]

Well I think some have pointed out the issues with a online web
forum, logging in, lack of email notifications?

Mailing lists are one aspect of the Internet that in the last
25yrs has not disappointed me. Keeping the mailing list seems
to work or the irc option perhaps.

With that being said I would really like the Internet too take
a major change, to a model that is more distributed instead of
web server oriented. Something more like Steam.

With that in mind I have been working on a framework, and I'm
now trying to come up with a mechanism for I guess might be called
a forum of some type. One way or another I will implement something
and would be willing to work/experiment on this for perhaps a
solution that might meet communications needs of the list.

Dana Proctor
http://dandymadeproductions.com/projects/lindyFrame/lindyFrame_about.html

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

Re: [sqlite] Best way to develop a GUI front-end

[dmp]

> Date: Mon, 13 Nov 2017 15:54:42 -0600
> From: Balaji Ramanathan 
> To: sqlite-users@mailinglists.sqlite.org
> Subject: [sqlite] Best way to develop a GUI front-end
>
> Hi,
>
> I have been using SQLite without any programming language so far.  I
> maintain the data in 
> ~
> ~
> ~
> Is there a third party free tool like MS Access that would allow me to
> connect to a SQLite db in the back-end and enable me to create a custom
> front-end to it with forms and reports?  All my searches for this kind of
>  tool only lead me to tools like SqliteStudio, which is a GUI front end
> for SQLite, but not a programmable one like I want.  If anyone can point
> me towards a programmable GUI front-end development tool (preferrably
> open-source, but just free and well-maintained is sufficient), I would
> appreciate it greatly.
>
> Thank you very much.
> Balaji Ramanathan

Hello,

I have several times posted, indicating the release of my database GUI,
Ajqvue. It is a well maintained, mature open source project that was
started in 2005 then renamed in 2016, because of a cease-desist from
Oracle.

The project language is in Java and was started on Sourceforge and is
now hosted on GitHub.

https://github.com/danap/ajqvue

Ajqvue is a framework that so happens to have as its main plugin a
database interface. The interface is more in line with a spreadsheet
application rather than a tree db/table selector display, with a manual
query entry form. The database interface is JDBC, which most of the
databases have available. For SQLite I have been using:

https://github.com/xerial/sqlite-jdbc

Ajqvue comes with several additional plugins for analysis, and plotting.
I believe the most versatile aspect of Ajqvue though is the ability
through the Query Bucket to save composed SQL queries. Those queries
can then be dragged/dropped into plugins to allow data processing.

A plugin of a custom form should be relatively easy to create if you
know Java. There is a tutorial available on the documentation page
of the site along with videos demonstrating the desktop application.
Once a plugin is created it can be sourced locally, LAN, or on the
Internet.

If you do create a plugin GUI I recommend Swing over JavaFX. I have
had issues on various, Linux platforms with JavaFX and just switched
the charting plugin from JavaFX to JFreeChart.

Dana Proctor
Ajqvue Project Manager
http://ajqvue.com


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

Re: [sqlite] SQLite Port/ODBC Driver Question

[dmp]

Hello Vishal,

As far as I know the Java version of the Werner javasqlite
driver does not use a port and the odbc may not also.

I have use this Java driver, but a more current active
driver project for Java is at GitHub:

https://github.com/xerial/sqlite-jdbc/

As indicated SQLite is local file system database. Though
I have tested the sqlite-jdbc driver on Win with a mapped
network drive. The stability of that mode of operation is
questionable, as can be searched on this forum's discussions.

danap.

> Hi,
> Am trying to open a firewall to the machine having sqlite database. Does
the SQLite
> database use a specific port number ? If not, then does the ODBC
connection to
> SQLite using ODBC driver use a port ?

> Any help will be greatly appreciated.

> SQLite ODBC Driver:
> http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe

> Regards,
> Vishal Shukla

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

[sqlite] Subject: Re: sqlite with Java

[dmp]

> From: Sylvain Pointeau
>
> Why don't you provide an up-to-date version? this lib seems dead when we
> look at the website, also why don't you put the sources on git it would be
>  easier to contribute or raise a bug if any...
>
> --

I first supported SQLite in my project Ajqvue in 2010 and started out
with Werner's library. At some point I moved on to the Github xerial
sqlite-jdbc mainly for that reason, was being updated.

I can think of no real reason other than that. Maybe in the documentation
something about the Pure Java Mode.

There should be no problem between the H2 -> SQlite, Ajqvue supports
both, though H2 has the more convention database Data Types. There are
some SQL statement that H2 supports and not SQLite. Been awhile since
reviewed might not be so now.

Data Type Conversions:
https://github.com/danap/ajqvue/blob/master/src/com/dandymadeproductions/ajqvue/datasource/TypesInfoCache.java

SQL Statements See: Table 1.
http://ajqvue.com/docs/Manual/Ajqvue_Manual.html

danap.

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

Re: [sqlite] confused getting started

[dmp]

> I'm not a computer novice, but also not a nerd/geek.
> Been using PCs since the mid 1980s and have used dBase III+ and Approach
> previously.
>
> I can't seem to grasp what I need to download / install to use SQLite?
>
> Can someone guide me through the process?  Looking to use it with
> RootsMagic.
>
> Thank you.
> John

Hello John,

If you just wish to quickly get access to a SQLite database file
then perhaps Ajqvue may help. I have had no problem with accessing
non-password protected files, such as places.sqlite that Firefox
uses. An encrypted database file though may not work with Aqjvue.

See the Quick Tutorial and use the default example database,
Site | LocalHost_SQLite | test/sqlite_db/factbook.db, to get
started.

http://ajqvue.com/
http://ajqvue.com/docs/Videos/Ajqvue_Quick.mp4

The command line tool as Simon indicated is much more powerful
and can then be explored to futher your goals.

danap.

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

Re: [sqlite] Quest for "scratch table" implementation in SQLite.

[dmp]

> I'm still trying to figure out a graceful way to implement
> a "scratch" database table that has the following properties:

> o Can be created on demand while a database connection is open.
> o Can include references to other material in the database to
>   ensure integrity.
> o Will be automatically deleted when the database is closed.
>
> TEMPORARY tables can't do the second bullet, as I understand it.
>
> Right now I have application code that manages such tables,
> but it seems clunky and error-prone.  Am I missing any SQLite
>  feature that would let me do this more easily?
>
> Thanks for any suggestions.
>
> Randall.

I have a Java program that is used as a plugin for my application
that can before a query on a database that then creates a mem/file
database of the data. Not sure if it would meet point 2. Still
needs some work because it works with other databases also, but
the SQLite to SQLite should be fine.

danap.

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

Re: [sqlite] SQLite3 Tutorial error

[dmp]

> Message: 21
> Date: Wed, 4 Jan 2017 22:10:59 -0600
> From: Ken Wagner 
> To: SQLite mailing list 
> Subject: Re: [sqlite] SQLite3 Tutorial error

> Yes, I am beginning to understand that. SQLite3 is its own GLOB standard.

> I will abide by that.

> It is just very confusing when 5 other apps using SQLite as their DB
> engine all report the opposite.
>  The SQLite versions they use are 3.9.2, 3.10.1, 3.11.0 and 3.13.0.

> Example: the SQLite Manager in FireFox 50 uses SQLite 3.13.0 and
> faithfully removes the names with digits in them.

I tried the example from R. Smith and got the exact same results
in my own SQLite Interface, Ajqvue, using the SQLITE JDBC.

I don't know what those other apps may be doing, but they should
just pass the query created by the user "DIRECTLY" to the SQLite DB
engine without any modification. Likewise the result should also
not be mucked with before presentation.

danap.

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

[sqlite] Ajqvue 1.11 Released

[dmp]

The Ajqvue project is pleased to release v1.11 to the public. The
release is a minor one to highlight an update to the QueryBuilder
plugin. In addition to the QueryBuilder plugin the application
comes with by the HeatMapper, JavaFX Charts, and Table Field
Profiler plugins. The SQLite JDBC is an included library along
with the World Factbook database.

Dana M. Proctor
Ajqvue Project Manager
http://ajqvue.com

Ajqvue provides an easy to use Java based user interface front-end
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.

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

[sqlite] Ajqvue Version 1.10 Released

[dmp]

Ajqvue Version 1.10 Released

The Ajqvue project is pleased to release v1.10 to the public. The
release marks a complete code review and cleanup. Updated libraries have
also been included with this release along with the Table Field Profiler
plugin. There have been many fixes in this release that stabilizes the
application.

The Ajqvue application is the recent result of replacing a 11 year old
Open Source program that has been challenged by a major player in the
database market for trademark infringement. Unable to defend the project
from such a mammoth that project is now dead, and replaced with Ajqvue.
As a result much of the old project as now been consolidated and resulted
in a much cleaner code base and website. An overview video of the
capabilities of the application is available at the link below. Ajqvue
uses the SQLite JDBC Driver and is included as a library with the
application.

http://ajqvue.com/docs/Videos/Ajqvue_Overview.mp4
https://github.com/xerial/sqlite-jdbc

Dana M. Proctor
Ajqvue Project Manager
http://ajqvue.com

Ajqvue provides an easy to use Java based user interface front-end
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.

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

[sqlite] MyJSQLView Version 7.08 Released

[dmp]

MyJSQLView Version 7.08 Released

The MyJSQLView project is pleased to release v7.08 to the public. The
release marks a complete code review and cleanup. Updated libraries have
also been included with this release along with the Table Field Profiler
plugin. There have been many fixes in this release that stabilizes the
application.

Dana M. Proctor
MyJSQLView Project Manager
http://myjsqlview.com

MyJSQLView provides an easy to use Java based user interface front-end
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.

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

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

[dmp]

I'm not interested in mobile browsing, just that the site is
still acceptable after changes for desktop. I use unconventional
browsers included one of my own design.

The draft site looks and works fine, is fast for loads, doesn't
seem to require scripting, GOOD!

danap.

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

Re: [sqlite] SQL to SQLite

[dmp]

> Thanks Dana,

> I think you're talking about doing what I did, but I'm not 100% sure.

> Below is my solution.  Could you let me know if yours is the same or
> something more elegant?

Hello,

I'm not sure of the programming language, VBasic, ?, but generally
looking through it looks like essentially what I indicated and my code
does.

So to summarize your options, others indicated also.

Note: 1. & 2. imply different source database.

1. Dump the data, CSV/SQL, format from the source database,
   then import into the new destination SQLite database.
   Somewhat easy, but manual so slow. Could code the import
   export together to improve efficiency.

2. Do a database to database transfer, much harder, to get
   right, mainly because the data type conversions. Looks
   like you code is taking into account and SQLMate could
   help. Relatively fast.

3. If using SQLite to SQLite, looks like indicated on the
   mailing list use ATTACH. Seems the easiest approach
   and fastest.

danap.

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

Re: [sqlite] SQL to SQLite

[dmp]

> Message: 2
> Date: Tue, 19 Jul 2016 15:01:55 -0700
> From: 
> To: 
> Subject: [sqlite] SQL to SQLite
> Message-ID: <004d01d1e209$2a356360$7ea02a20$@spotlightmusic.com>
> Content-Type: text/plain; charset="us-ascii"
>
> What's the best way to Insert or Update records from a connected SQL
> database to the connected SQLite database?
>
> I don't mean just once, but to do every so often.
> Thanks.

> Thanks for your response.

> Programming language is definitely the way I want to go, and in fact I
> programmed a workaround, but I assume I took the long way around and that
> there's a more standard way to do it.

Hello,

   If the source database is different, or SQLite, than the destination
database, SQLite, can be done and I have been working on a bridge in Java
that will perform the transfer. It is functional, but needs further work
and testing.

Essentially:

Create an ArrayBlockingQueue, start a LoadThread and a InsertPrepareThread.
Define the ArrayBlockingQueue as objects of a relation row element. Have
the load thread fill the blocking queue then the insert prepare thread
consume the table row elements from the queue.

A single SQL query can be used to define the SQLite table then fill it
with the source database data. A type definitions conversion needs to
take place to correctly transfer db --> db data types.

I have defined these type info conversions for various database and
it is available as part of my MyJSQLView project. At this time the
db --> db code is a plugin for MyJSQLView and is not been released to
the public.

https://github.com/danap/myjsqlview/blob/master/src/com/dandymadeproductions/myjsqlview/datasource/TypesInfoCache.java

Dana Proctor
MyJSQLView Project Manager

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

[ANNOUNCE] MyJSQLView Version 7.03 Released

[dmp]

The MyJSQLView project is pleased to release v7.03 to the public. The
release is to fix the plugin management tool proxy setting property.
Remote HTTP repositories can not be created or loaded. The release
also is for archiving purposes to finalize the last release before
the move of the code version control from Google Code to an alternative
private server.

Dana M. Proctor
MyJSQLView Project Manager
http://myjsqlview.com

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.


--
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce

[sqlite] Why is empty string not equal to empty blob?

[dmp]

 > You explicitly put strings into both columns.  The two values are the same
 > even though you declared the columns differently.  As I told you before,
 > if you want to see what type something is, use typeof(thing).
 >
 > ~
 > ~
 > ~
 > ~
 >
 > Simon.

Thank you guys. I follow this list so I may keep informed to the
happenins with SQLite for my project.

I have been having an issue on how to handle a defined DATE column.
Be it NUMBER, or TEXT with the sqlite-jdbc. If its value is TEXT
and I try to retrieve with getDate() a parsing error will occur
if its format is not correct, but if I handle it with getString()
no problem, don't care.

These responses helped to clarify what is going on and how to deal
with mixed type column content.

typeof(thing). :)

danap.

[ANNOUNCE] MyJSQLView Version 3.48 Released

[dmp]

MyJSQLView Version 3.48 Released

The MyJSQLView project is pleased to release v3.48 to the public. The
release marks support for an addition database product and an update
to the Visual QueryBuilder plugin.

Dana M. Proctor
MyJSQLView Project Manager
http://myjsqlview.org

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile and
plot data for analysis.


--
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce

[Trisquel-users] Wine on Trisquel 6.0

[dmp . mail]

I'm attempting to install Wine from Synaptic. It seems 1.2, 1.3, and 1.4 are  
all there.


1.4 proclaims to be a broken package when you select it, and 1.2 and 1.3 tell  
me this: Depends: wine1.4 but it is not going to be installed.


I've attempted to manually install Wine as well, but I receive an error  
regarding held broken packages.


I'm relatively new to the GNU/Linux world, so please have patience with me.  
:)


Thanks in advance for any guidance you can provide.

-favo

[ANNOUNCE] MyJSQLView Verrsion 3.47 Released

[dmp]

MyJSQLView Version 3.47 Released

The MyJSQLView project is pleased to release v3.47 to the public. The
release marks the support for the H2 database and its inclusion as a
library with the application. H2 provides an additional focal point
for allowing locale file and in-memory data analysis for MyJSQLView
and its plugins. Architectural changes for MyJSQLView have also been
implemented with v3.47 that ease the ability to create alternate
database connections within the application. The Heat Mapper plugin
has also been updated to allow CSV imports for analysis.

Congratulations to the PostgreSQL community for further penetration
into the market place this week by an announce with Amazon of database
service instances.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface frontend
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visually build queries, profile
and plot data for analysis.



--
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce

[ANNOUNCE] MyJSQLView Version 3.41 Released

[dmp]

MyJSQLView Version 3.41 Released

The MyJSQLView project is pleased to release v3.41 to the public. The
release marks seven years, 2005, since the application was first started
in a small sparse apartment in Fairview, OR USA. This current release
now includes the graphical SQL query builder, QueryBuilder, plugin as
a default in the tool. The project this year will continue to offer new
features and plugins to expand upon the tools longevity.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visual build queries, profile and
plot data for analysis.


--
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce

[Moses-support] How to set up Moses Online Demonstrations

[dmp]

   Hello, I am a student and I want to set up Moses Online Demostrtions. But I 
don't know how to build it. I search it in your sit but I just find a little 
message about it. In  Web Translation  and  Web Interface  ,there is some 
information about that. But I also have problem.
1. How to use moses to set up a system just like google translation.
2.Does moses Support web function? Or I should write script to Handle the 
requst from web.
3.If moses support web function,how can I use it.
   would you give me detailed answers. Or give some document about it. Thank 
you very much. ___
Moses-support mailing list
Moses-support@mit.edu
http://mailman.mit.edu/mailman/listinfo/moses-support

[ANNOUNCE] MyJSQLView Version 3.40 Released

[dmp]

MyJSQLView Version 3.40 Released

The MyJSQLView project is pleased to release v3.40 to the public. The
release marks a major reorganizational effort to the source code and plugin
management. Though the public will notice little with regard to the source
subpackaging the plugin management changes bring the ability to now load plugins
from remote locations. Plugin repositories can now be created by individuals or
organizations that wish to provide custom plugins on the basis of a realtime
network loading capability. In that regard the MyJSQLView project has added to
its own public repository a free open source plugin that contains a graphical
SQL query builder.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to profile and plot data for analysis.


--
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce

[ANNOUNCE] MyJSQLView Version 3.35 Released

[dmp]

The MyJSQLView project is pleased to release v3.35 to the public. The
release is a maintenance update to address several issues that manifest
themselves when using the SQL Query Bucket and Query Frame. Drops to the
Query Bucket from the main summary table fail to properly create the
syntax as derived from the search and sort parameters in the Summary
Table. Fixes to the Query Frame now allow the use of aliases. The
application has also been updated to remove legacy data structures
that had decrease the efficiency of the application.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to profile and plot data for analysis.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[ANNOUNCE] MyJSQLView Version 3.34 Released

[dmp]

MyJSQLView Version 3.34 Released

The MyJSQLView project is pleased to release v3.34 to the public. The
release is a maintenance update to address issues with data imports and
exports associated with database tables with 100k+ rows. Modifications
have been made to allow the control of table reads and writes by way of
a General Options Preferences. In addition the release as the prior one
makes improvements to the HeatMapper plugin. The TableFieldProfiler
plugin has also been expanded to include a cluster analysis tool as
was incorporated in the original Profiler project.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface frontend for
viewing, adding, editing, or deleting entries in the several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to profile and plot data for analysis.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[ANNOUNCE] MyJSQLView Version 3.31 Released

[dmp]

The MyJSQLView project is pleased to release v3.33 to the public. The
release includes improvements in the efficiency of use for the SQL Query
Bucket and an Aggregation/GROUP BY feature for the Advanced Sort/Search
Form. The new release also brings a new default plugin called HeatMapper
that allows the plotting of multi-variable numeric data. Initial tests
for the HeatMapper plugin used latitude, longitude, and temperature
data from measurements in the Alantic with over 90k records. The coding
for this plugin solidified the selection of HyperSQL for in memory data
analysis.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use free Open Source Java based user
interface frontend for viewing, adding, editing, or deleting entries
in several mainstream databases including PostgreSQL. A query frame
allows the building of complex SQL statements. The application allows
easy sorting, searching, and import/export of table data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[sqlite] GROUP BY With ASC/DESC

[dmp]

Given the following table:

DROP TABLE IF EXISTS key_table5;
CREATE TABLE key_table5 (
name TEXT NOT NULL default '',
color TEXT default NULL,
price REAL default NULL,
UNIQUE (name),
PRIMARY KEY (color)
);

I'm getting the following exception:

SQLException: [SQLITE_ERROR] SQL error or missing database (near "ASC": syntax 
error)


with:

SELECT name, color, Sum(price) AS price FROM key_table5 WHERE price > '2' GROUP 
BY color ASC ORDER BY name ASC LIMIT 50 OFFSET 0


when either ASC or DESC is used with the GROUP BY clause.

Is this a bug or a query statement inaccuracy on my part?

SQLite version 3.7.2 & 3.7.9.

danap.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] GROUP BY With ASC/DESC

[dmp]

Given the following table:

DROP TABLE IF EXISTS key_table5;
CREATE TABLE key_table5 (
name TEXT NOT NULL default '',
color TEXT default NULL,
price REAL default NULL,
UNIQUE (name),
PRIMARY KEY (color)
);

I'm getting the following exception:

SQLException: [SQLITE_ERROR] SQL error or missing database (near ASC: syntax 
error)


with:

SELECT name, color, Sum(price) AS price FROM key_table5 WHERE price  '2' GROUP 
BY color ASC ORDER BY name ASC LIMIT 50 OFFSET 0


when either ASC or DESC is used with the GROUP BY clause.

Is this a bug or a query statement inaccuracy on my part?

SQLite version 3.7.2  3.7.9.

danap.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[ANNOUNCE] MyJSQLView Version 3.31 Released

[dmp]

The MyJSQLView project is pleased to release v3.31 to the public.
Included with this update is several corrections for bugs involved
with the import of large SQL dumps and table definition generation
for unique keys. A multi-language PDF export inclusion is now
implemented via unicode embedded fonts. The Query Frame in the
application has now been expanded to allow input of direct SQL
statements for execution.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use free Open Source Java based user
interface frontend for viewing, adding, editing, or deleting entries
in several mainstream databases including PostgreSQL. A query frame
allows the building of complex SQL statements. The application allows
easy sorting, searching, and import/export of table data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[ANNOUNCE] MyJSQLView Version 3.30 Released

[dmp]

MyJSQLView Version 3.30 Released

The MyJSQLView project has released a preliminary production version to
address several reported problems with the application. Since this release
is to correct these bugs a more fully vetted release will be forth coming
by the end of the month or early next.

The release Version 3.30 corrects the running of the application
on specifically the Ubuntu Linux OS with the Gnome desktop. Because of
the type of bug that was discovered it is possible this may effect all
uses of the application on the Gnome desktop. The second issued addressed
by the release is the lack to properly export PDF Summary Table data. A
failure on the project to properly build the last release with an updated
iText library file inclusion was the cause.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface
frontend for viewing, adding, editing, or deleting entries in
the HSQL, MySQL, Oracle, PostgreSQL, and SQLite databases. A
query frame allows the building of complex SELECT SQL statements.
The application allows easy sorting, searching, and import/export
of table data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[il-antlr-interest: 32749] [antlr-interest] Comments in Tcl - Lexer

[dmp]

Hello,

I'm working with Antlr to provide syntax highlight for Tcl (in
Netbeans). I have a problem with COMMENT token.
Basic version for one line comment looks like this:

COMMENT :
 '#' (options {greedy=false;} : .)* NEWLINE
;

But comment in Tcl starts only at the beginning of a line with
optional whitespace or after ; also with optional whitespace.
How can I handle this using antlr grammar and lexer?

I've already allowed to use '#' in IDs:
ID :
 ('a'..'z'|'A'..'Z'|'0'..'9'|'_'|'#')+
;

It's difficult to find simple solution because char stream provided
from Netbeans it's not full source but only parts displayed/edited. I
followed some tips from this mailing list for example:
http://wklej.org/id/544171/ but It doesn't solve my problem.

I would be grateful if someone could give me some advices.

Thanks,
dmp

List: http://www.antlr.org/mailman/listinfo/antlr-interest
Unsubscribe: 
http://www.antlr.org/mailman/options/antlr-interest/your-email-address

-- 
You received this message because you are subscribed to the Google Groups 
il-antlr-interest group.
To post to this group, send email to il-antlr-inter...@googlegroups.com.
To unsubscribe from this group, send email to 
il-antlr-interest+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/il-antlr-interest?hl=en.

[ANNOUNCE] MyJSQLView Version 3.26 Released

[dmp]

MyJSQLView Version 3.26 Released

The MyJSQLView project is pleased to provide the release of Version
3.26 to the public. The release is minor in nature with changes mainly
involving the modularization of core aspects of the architecture for
login and connection code. An addition was also made to the Preferences
Menu system for allowing the selection of the date format display.
In that regard the application will now perform searches with the
selected default date format. A number of other minor changes were
accomplished that should enhance the visual aspect of certain parts
of the application's interface.

With the release of v3.26 of the MyJSQLView application the group
would like to notify the PostgreSQL community of changes in that
organization's database and JDBC with version 9.0X that make prior
versions of MyJSQLView non-functional. Please update MyJSQLView to
v3.26 if you are using the latest release of PostgreSQL. A Report of
the problem has been given specifically to the JDBC forum and has
been addressed, but no new version of the JDBC has been issued as
of the date of this news release.

Users should also note that the changes in code for the login and
connection management with v3.26 make prior plugins to this incompatible.
A great deal of efforted was taken to try and make the initial plugin
architecture stable and fixed, but sometimes even carefully conceived
thought processes are lay to waste. With that note we have updated
the tutorials at the Website to facilitate plugin development.


Dana M. Proctor
MyJSQLView Project Manager

MyJSQLView provides an easy to use Java based user interface
frontend for viewing, adding, editing, or deleting entries in
several open source databases including PostgreSQL. A query frame
allows the building of complex SELECT SQL statements. The
application allows easy sorting, searching, and import/export
of table data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[sqlite] MyJSQLView Version 3.23 Released

[dmp]

MyJSQLView Version 3.23 Released

The MyJSQLView project is pleased to provide the release of Version
3.23 to the public. The release marks the addition of support for
the SQLite database. New to this release of MyJSQLView is also the
support for in memory databases that is featured for both the SQLite
and HSQL databases. What this means is data sets can now be imported
into a table and MyJSQLView should be able to perform quicker searches
and sorts of the in memory data. The group has also abandoned the
practice of not including some of the open source plugins for the
application that it produces. The last release of the application
did not include the TableFieldProfiler plugin with MyJSQLView and
as a result the downloads of that plugin amounted to less then
5% of the total MyJSQLView downloads. The group thought users were
really missing out on a valuable tool which had been expanded and
included internationalization. So the TableFieldProfiler is now
included with the standard MyJSQLView download.

This release of MyJSQLView has also enhanced the plugin architecture
by letting users manually load plugins from alternative directories
than the default lib/plugins directory. You will find access to
the Plugin Management Tool in the top main tab menu for the application.
Speaking of plugins, developers will now find the Plugin Basics Tutorial
has been updated and an advanced one has also been created under
the documentation of the web site.

Since this is a release that supports a new database make sure and
check out the additional entries that have been given for the connection
parameters in the example reference myjsqlview.xml file. We would
also like to let you know that a new database is available at the
web site for the US Congress. The data set is of the legislative
branches' representatives, courtesy of Sunlight Labs.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface
frontend for viewing, adding, editing, or deleting entries in
the the SQLite databases. A query frame allows the building of
complex SELECT SQL statements. The application allows easy sorting,
searching, and import/export of table data.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] MyJSQLView Version 3.23 Released

[dmp]

MyJSQLView Version 3.23 Released

The MyJSQLView project is pleased to provide the release of Version
3.23 to the public. The release marks the addition of support for
the SQLite database. New to this release of MyJSQLView is also the
support for in memory databases that is featured for both the SQLite
and HSQL databases. What this means is data sets can now be imported
into a table and MyJSQLView should be able to perform quicker searches
and sorts of the in memory data. The group has also abandoned the
practice of not including some of the open source plugins for the
application that it produces. The last release of the application
did not include the TableFieldProfiler plugin with MyJSQLView and
as a result the downloads of that plugin amounted to less then
5% of the total MyJSQLView downloads. The group thought users were
really missing out on a valuable tool which had been expanded and
included internationalization. So the TableFieldProfiler is now
included with the standard MyJSQLView download.

This release of MyJSQLView has also enhanced the plugin architecture
by letting users manually load plugins from alternative directories
than the default lib/plugins directory. You will find access to
the Plugin Management Tool in the top main tab menu for the application.
Speaking of plugins, developers will now find the Plugin Basics Tutorial
has been updated and an advanced one has also been created under
the documentation of the web site.

Since this is a release that supports a new database make sure and
check out the additional entries that have been given for the connection
parameters in the example reference myjsqlview.xml file. We would
also like to let you know that a new database is available at the
web site for the US Congress. The data set is of the legislative
branches' representatives, courtesy of Sunlight Labs.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface
frontend for viewing, adding, editing, or deleting entries in
the the SQLite databases. A query frame allows the building of
complex SELECT SQL statements. The application allows easy sorting,
searching, and import/export of table data.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[ANNOUNCE] MyJSQLView Version 3.23 Released

[dmp]

MyJSQLView Version 3.23 Released

The MyJSQLView project is pleased to provide the release of Version
3.23 to the public. The release is minor in relation to the PostgreSQL
community, but does mark additions to the plugin architecture. The
group has abandoned the practice of not including some of the open
source plugins for the application that it produces. The last release of
the application did not include the TableFieldProfiler plugin with
MyJSQLView and as a result the downloads of that plugin amounted
to less then 5% of the total MyJSQLView downloads. The group
thought users were really missing out on a valuable tool which had
been expanded and included internationalization. So the TableFieldProfiler
is now included with the standard MyJSQLView download.

This release of MyJSQLView has also enhanced the plugin architecture
by letting users manually load plugins from alternative directories
than the default lib/plugins directory. You will find access to the Plugin
Management Tool in the top main tab menu for the application.
Speaking of plugins, developers will now find the Plugin Basics
Tutorial has been updated and an advanced one has also been created
under the documentation of the web site.

Since this is a release that supports a new database make sure and
check out the additional entries that have been given for the connection
parameters in the example reference myjsqlview.xml file. We would
also like to let you know that a new database is available at the
web site for the US Congress. The data set is of the legislative
branches' representatives, courtesy of Sunlight Labs.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/index.html

MyJSQLView provides an easy to use open source Java based interface
for viewing, adding, editing, or deleting entries in a PostgreSQL database.
A query frame allows the building of complex SELECT SQL statements.
The application allows easy sorting, searching, and import/export of table
data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[ANNOUNCE] MyJSQLView Version 3.22 Released

[dmp]

MyJSQLView Version 3.22 Released

The MyJSQLView project is pleased to provide the release of
Version 3.22 to the public. The release marks the completion of
the architecture for a modular plugin framework with a threaded
loader. New to the v3.22 release is the ability to  generate a PDF
document of the summary table data. The code has also undergone
a major rebuild to bring the application into compliance with the
Java 1.5 API. The program will now need to be run on a platform
that has the at least the JRE 5.0.

A note to users that the MyJSQLView application will now no
longer come with any plugin modules. For the past two releases
the Table Field Profiler was included as part of the download,
but users will now need to download that plugin and others
separately. The good news is the project has been able to fully
expand the Table Field Profiler module to include a table field
analysis panel. Please see the Plugins section of the MyJSQLView's
Web Page to gain access to the module.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/index.html

MyJSQLView provides an easy to use open source Java based interface
for viewing, adding, editing, or deleting entries in a PostgreSQL 
databases.

A query frame allows the building of complex SELECT SQL statements.
The application allows easy sorting, searching, and import/export of table
data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[android-developers] Flash usage in android 2.2

[dmp]

Hi,

I am aware that we can create our own flash files and run it on
android.
I have tried doing this and it works.

But I don't see how we can connect android data such as pictures in
sdcard or gallery or contact information, such that it can be used in
flash.
eg, some cool way of animating images in the gallery.-- using flash

I am new to flash so I am not sure how to do this.
Is this possible using flash ?
If so, can you just point me to a few starters on how this can be
done ?

Thanks.

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Re: [JDBC] [BUGS] JDBC: 2 bugs: Getting a smallint array actually gets an integer array and return type of a boolean array is bit.

[dmp]

Hi,

I think I found two bugs (and I hope I am not wasting everyone's 
time).
One is minor: the base type of a boolean[] is java.sql.Types.BIT 
instead or java.sql.Types.BOOLEAN.  At the very least shouldn't these 
be aliases for the same type?


And secondly the returned type from a smallint[] is an Integer[] 
instead of a Short[].




So running this code: 




The running of the supplied code also gives the same results with 
PostgreSQL 8.3.3


results:

sun.jdbc.odbc.jdbcodbcdri...@fc9944: 2.1
org.postgresql.dri...@8b819f: 8.4
PostgreSQL 8.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
Integer[]
1 2
int4: 4 4
END  Integer[]
Boolean[]
false true
bool: 16 -7   -7
END  Boolean[]
Short[]
java.lang.ClassCastException: [Ljava.lang.Integer; cannot be cast to 
[Ljava.lang.Short;



The 8.4 JDBC Driver though does gives a consistent result as past 
versions via the

tableMetaData.getColumnClassName()  tableMetaData.getColumnTypeName()
for the base types, integer, smallint, and boolean.

System.out.println(i +   + colNameString +   +
   columnClass +   + columnType +   +
   columnSize);

3 int_type java.lang.Integer int4 11
2 smallint_type java.lang.Integer int2 6
21 boolean_type java.lang.Boolean bool 1

1 ia java.sql.Array _int4 11
2 sa java.sql.Array _int2 6
3 ba java.sql.Array _bool 1

Attached slight modification to NewClass to correctly compile and drop 
table if run

more than once.

danap.


public class NewClass2
{
   public static void main(String[] args)
   {
  try
  {

 Class.forName(org.postgresql.Driver);
 java.sql.Connection conn = java.sql.DriverManager.getConnection(
jdbc:postgresql://192.168.157.32:5432/dev, dev, devmm);
 java.util.Enumerationjava.sql.Driver drivers = 
java.sql.DriverManager.getDrivers();
 while (drivers.hasMoreElements())
 {
java.sql.Driver d = drivers.nextElement();
System.out.println(d.toString() + :  + d.getMajorVersion() + . 
+ d.getMinorVersion());
 }

 java.sql.PreparedStatement ps_ver = conn.prepareStatement(SELECT 
version());
 java.sql.ResultSet rs = ps_ver.executeQuery();
 while (rs.next())
System.out.println(rs.getString(1));
 
 
 java.sql.Statement dbStatement = conn.createStatement();
 dbStatement.executeUpdate(DROP TABLE IF EXISTS public.aab);
 
 java.sql.PreparedStatement ps_create = conn.prepareStatement(CREATE 
TABLE public.aab (
   + ia integer[],  + sa smallint[], 

   + ba boolean[] ));
 ps_create.executeUpdate();

 java.sql.PreparedStatement ps_insert = conn
   .prepareStatement(INSERT INTO public.aab (ia,sa,ba) VALUES 
(?,?,?));
 ps_insert.setArray(1, conn.createArrayOf(int4, new Integer[] {1, 
2}));
 ps_insert.setArray(2, conn.createArrayOf(int2, new Short[] {100, 
200}));
 ps_insert.setArray(3, conn.createArrayOf(bool, new Boolean[] {false, 
true}));
 ps_insert.executeUpdate();

 java.sql.PreparedStatement ps_select = conn.prepareStatement(SELECT 
ia,sa,ba FROM public.aab);

 rs = ps_select.executeQuery();

 java.sql.Array jdbcArr;

 while (rs.next())
 {

System.out.println(Integer[]);
jdbcArr = rs.getArray(ia);
Integer[] javaIntArr = (Integer[]) jdbcArr.getArray();
System.out.println(javaIntArr[0] +   + javaIntArr[1]);
System.out.println(String.format(%s: %d %d, 
jdbcArr.getBaseTypeName(), java.sql.Types.INTEGER,
   jdbcArr.getBaseType()));
System.out.println(END  Integer[]);

System.out.println(Boolean[]);
jdbcArr = rs.getArray(ba);
Boolean[] javaBooArr = (Boolean[]) jdbcArr.getArray();
System.out.println(javaBooArr[0] +   + javaBooArr[1]);
System.out.println(String.format(%s: %d %d   %d, 
jdbcArr.getBaseTypeName(),
   java.sql.Types.BOOLEAN, jdbcArr.getBaseType(), 
java.sql.Types.BIT));
System.out.println(END  Boolean[]);

System.out.println(Short[]);
jdbcArr = rs.getArray(sa);
Short[] javaShoArr = (Short[]) jdbcArr.getArray();
System.out.println(javaShoArr[0] +   + javaShoArr[1]);
System.out.println(String.format(%s: %d %d, 
jdbcArr.getBaseTypeName(), java.sql.Types.SMALLINT,
   jdbcArr.getBaseType()));
System.out.println(END  Short[]);
 }
 rs.close();
 dbStatement.close();
 conn.close();
  }
  catch (Exception e)
  {
 System.out.println(e.toString());
  }
   } // main
} // class

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your 

[ANNOUNCE] MyJSQLView Version 3.17 Released

[dmp]

MyJSQLView Version 3.17 Released

The MyJSQLView project is pleased to provide the release of
Version  3.17 to the public. The release marks the cumulative
effort of many years now to complete an easy to use framework
for database access, and versatility through a plugin environment.
Several enhancements have been implemented in this release
to improve network performance and proper searches in the
database with regard to date fields. Included in the v3.17
release too is Internationalization, i18n.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/index.html

MyJSQLView provides an easy to use open source Java based interface
for viewing, adding, editing, or deleting entries in a PostgreSQL databases.
A query frame allows the building of complex SELECT SQL statements.
The application allows easy sorting, searching, and import/export of table
data.

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  pgsql-announce-unsubscr...@postgresql.org

[GENERAL] Table Column Retrieval

[dmp]

Recently I read that one of the distinctions between a standard database  
and
a columnar one, which led to an increase in its efficiency, was and I  
quote:


Only relevant columns are retrieved (A row-wise database would pull
all columns and typically discard 80-95% of them)

Is this true of PostgreSQL? That eventhough my query does not call for a
column it is still pulled from the table row(s). I know that my client via
the JDBC does not contain the data in the ResultSet for the column, because
of the packet monitoring I have done on queries.

danap

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[ANNOUNCE] MyJSQLView Version 2.86 Released

[dmp]

The MyJSQLView Beta release has been update to Version 2.86.
Several minor bugs were fixed in the release in addition to proper
support for PostgreSQL Version 8.3.0. Two new features were
also added, basic array data type support and the ability to import
delimited text files as either an insert or update.

MyJSQLView provides an easy to use Java based user interface
frontend for viewing, adding, editing, or deleting entries in
several open source databases. A query frame allows  the building
of complex SELECT SQL statements. The application  allows
easy sorting, searching, and import/export of table data.

MyJSQLView Project Manager
Dana M. Proctor
http://myjsqlview.sourceforge.net/


---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  [EMAIL PROTECTED]

Re: [GENERAL] pain of postgres upgrade with extensions

[dmp]

I noticed this immediately when using the PostgreSQL tool for examples of
dumps for creating export of database/table structure/data for the 
MyJSQLView
application. I considered implementing a similar copy dump, but seems it 
would

not be handled properly with SQL statements.
danap.



This is not a flame about current or previous release of Postgres.

I have just gone through the awful experience of upgrading from Postgres
8.2 to 8.3 with a database that had one of the many Postgres extensions
included. The problem comes down to the way that Postgres extensions are
packaged up, each extension tends to define some extension specific
functions, when you do a dump of the database these functions get include.
If upgrade from one version of Postgres to another, you take a dump of
the database, which then needs to be upgrade if there have been any
changes in the extension.  The problem being that there doesn#8217;t seem
to be a way of dumping the database with out including extension specific
information.

There is a possible solution to this problem, move all the extension
specific functions to an extension specific schema.  That way the contents
of the database are kept separate from extensions.

For example the postgis function area would change to postgis.area
assuming the the schema for postgis extension was call postgis, this would
also avoid the problem if two extensions happen to have a function with
the same name.

D.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how do you write aggregate function

[dmp]

Array appends are usually a performance hit, as you said. I'm not sure 
though with
PostgreSQL. Why not try it with two arrays and see what happens. At 
least you would

reducing the single array and the eliminating the append.

danap.

I got the aggregate function for weighted average done.   I finely 
left alone for more than 10 minutes  to actual get it written.  It 
takes 2 value input  Weight and the Value.  it will sum the weighted 
entries to create the constant then does the normal formula, but does 
not percentage number but averaged number.  A simple change on the 
return line it can do percentages.


I did a couple of  things a little odd .  instead of doing a multi 
dimensional array i did a one dimensional array where the 1st row is 
Weight and the  2nd row is Value.   This made the loop through the 
array look stupid.
I tested it across 50,000 records with a group by it took 3.3 seconds 
to run.


without the group by clause performance is terrible taking several 
minutes just to do the sfunc part. 371,563ms


The Array seems to have performance hit any advice?It could be the 
way i'm appending to the Array which has a performance hit as the 
array gets bigger and bigger ?



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how do you write aggregate function

[dmp]

Justin,
I'm really not a expert in this area, on how to code this, or functions in
PostgreSQL. All I could offer is some ideas which you might try. Sometimes
this is all it takes. Perhaps someone else will respond that might be more
helpful. With that said I have read in the documentation the use of other
languages and if you are looking for a higher performance, that is the
way I would said its going to come about perhaps.

danap.


DMP   you did give me an idea on changing how to call the append array
sfunc looks like this

create or replace function wcost_average_sf (numeric[],  numeric, 
numeric)

returns numeric[] as
$Body$
   begin
   return array_append(array_append($1, $2), $3);
   end;
$Body$
LANGUAGE 'plpgsql' VOLATILE;

this yanked out 140,000 ms   on the run time,  a big improvement but 
no where i want it to be.


are there speed improvements in the other languages TCL

dmp wrote:

Array appends are usually a performance hit, as you said. I'm not 
sure though with
PostgreSQL. Why not try it with two arrays and see what happens. At 
least you would

reducing the single array and the eliminating the append.

danap.

I got the aggregate function for weighted average done.   I finely 
left alone for more than 10 minutes  to actual get it written.  It 
takes 2 value input  Weight and the Value.  it will sum the weighted 
entries to create the constant then does the normal formula, but 
does not percentage number but averaged number.  A simple change on 
the return line it can do percentages.


I did a couple of  things a little odd .  instead of doing a multi 
dimensional array i did a one dimensional array where the 1st row is 
Weight and the  2nd row is Value.   This made the loop through the 
array look stupid.
I tested it across 50,000 records with a group by it took 3.3 
seconds to run.


without the group by clause performance is terrible taking several 
minutes just to do the sfunc part. 371,563ms


The Array seems to have performance hit any advice?It could be 
the way i'm appending to the Array which has a performance hit as 
the array gets bigger and bigger ?






--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Changing column names in tables 2

[dmp]

Hello Tony,
Perhaps this will help maybe not. Since the original data import
used quotes for the fields then any case was maintained in the
creation of the new table(s)  fields(s). Just take your original
import file and remove all the quotes, ,. Re-import and and
PostgreSQL will use all lowercase for the table(s) and field(s).
If psql is to much of a hassle, Just use MyJSQLView to dump
the database and removed the quotes, . You should of been able
to remove the quotes directly in MyJSQLView during the dump,
but I just tried it and it is broken. Edit | Preference | Data Export |
SQL, set empty string identifier. I always recommend backing up
data to get back where you started just in case things get screwed up,
so pg_dump everything before starting.

danap.


Tony Cade wrote:

 


There are too many fields to issue alter table commands to rename in SQL so
my question is , is it safe to use a query such as

select relfilenode from pg_class where relname='rates'
   



 


update  pg_attribute set attname=lower(attname) where attnum 0 and
attrelid= ( from above query)
   



Don't do that.  It's far better to create a shell script, or PL/pgSQL
function, whatever suits you, to get the table/column names from the
catalog and then produce the ALTER TABLE commands you need.

Playing directly with the catalogs is *never* supposed.



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

[GENERAL] PostgreSQL Array Use

[dmp]

Hello,
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to effect this support. Just a couple
of questions.

1. What Size, 10 or 100's, 1000's of elements?
2. Single or Multi-Dimensional?
3. What data types?

Any input would be welcome.
Thanks,
danap.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL Array Use

[dmp]

I was slightly confused. I'm really trying to identify what type
of support the project should provide to array types. Just from
the input so far, it looks like more needs to be done. If 100's to
1000's of elements are in an array type, the application is going
to have some problems. Presently it will adequately handle less
then 10 or 20 elements in multi-dimensional arrays, without
much problem with adding, editing,  viewing, but 100s to 1000s
of elements need a more robust  easy method to view and edit
elements. The data type of the array is not a real problem, except
bytea and some of the geometry types which have some specific
input form requirements. Text might be a problem if the byte
size is large.
danap.

On Mar 3, 2008, at 2:05 PM, Josh Trutwin wrote:


On Mon, 3 Mar 2008 20:48:55 +0100
Karsten Hilbert [EMAIL PROTECTED] wrote:


On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:


Where are you getting this information.


IMO the OP wanted to know how people *use* arrays, not how
one *can* use arrays.



That was my thought, sort of a poll.  Hopefully OP isn't confused
now.  :)



Ah, I sure was then :)

Erik Jones

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[ANNOUNCE] MyJSQLView Version 2.81 Released

[dmp]

The MyJSQLView Beta release has been update to Version 2.81.
The release has focused on the implementation of a generic
core for effectuation of additional database support. The
database chosen for the effort was PostgreSQL. MyJSQLView
in this release now supports all the basic features that
it has provided previously with the MySQL database, but
also with PostgreSQL. A new feature added in this release
is the ability to import CSV, comma separated values, into
a table. The ability to manipulate some additional data
types was also added to the release, boolean  bit types.
There were many other areas that the project would of liked
to improved upon, database export  array support for example,
but those and other aspects were not really identified as the
major goals for this release.

MyJSQLView provides an easy to use Java based user interface
frontend for viewing, adding, editing, or deleting entries in
the MySQL  PostgreSQL databases. A query frame allows the
building of complex SELECT SQL statements. The application
allows easy sorting, searching, and import/export of table
data.

http://myjsqlview.sourceforge.net/

MyJSQLView Project Manager
Dana M. Proctor

---(end of broadcast)---
-To unsubscribe from this list, send an email to:

  [EMAIL PROTECTED]

Re: [SQL] UTF8 encoding and non-text data types

[dmp]

Hi Steve,
Have you tried converting to a decimal type or cast for the cost field? 
If you
are gathering this data from a text field and  placing in a variable of 
type string
then using that variable in the insert statement it may be rejected 
because it is not
type decimal. This  has been my experience with trying to get input data 
from

user's textfields and placing in the db.

dana.


Thanks Steve,

Actually I do not insert text data into my numeric field.
As I mentioned given
create table t1 { name text, cost decimal }
then I would like to insert numeric data into column cost because 
then I can later benefit from numerical operators like SUM, AVG, etc


More specifically, I am using HTML, Perl and PG. So from the HTML 
point of view a textfield is just some strings. So my user would enter 
12345 but expressed in UTF8. Perl would get this and use DBI to insert 
it into PG


What I am experiencing now is that DB errors that I am trying to 
insert an incorrect data into column cost which is numeric and the 
data is coming in from HTML in UTF8


Mybe I have to convert it to ASCII numbers in Perl before inserting  
them into PG


Thanks
Medi


I understand PG supports UTF-8 encoding and I have sucessfully
inserted
Unicode text into columns. I was wondering about other data types such
as
numbers, decimal, dates

That is, say I have a table t1 with
create table t1 { name text, cost decimal }
I can insert UTF8 text datatype into this table with no problem
But if my application attempts to insert numbers encloded in UTF8,
then I
get wrong datatype error

Is the solution for the application layer (not database) to convert
the
non-text UTF8 numbers to ASCII and then insert it into database ?

Thanks
Medi

Hi Medi,

I have only limited experience in this area, but it sounds like you
sending your numbers as strings? In your example:

create table t1 { name text, cost decimal };

insert into t1 (name, cost) values ('name1', '1');

I can't think of how else you're sending numeric values as UTF8? I know
that Pg will accept numbers as strings and convert internally (that has
worked for me in some object relational environments where I don't
choose to cope with data types), but I think it would be better if you
simply didn't send your numeric data in quotations, whether as UTF8 or
ASCII. If you don't have control over this layer (that quotes your
values), then I'd say converting to ASCII would solve the problem. But
better to convert to numeric and not ship quoted strings at all.

I may be totally off-base and missing something fundamental and I'm
very open to correction (by anyone), but that's what I can see here.

Best regards,

Steve



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

Re: [SQL] UTF8 encoding and non-text data types

[dmp]

Sorry this should have been addressed to Medi
dana.


Hi Steve,
Have you tried converting to a decimal type or cast for the cost 
field? If you
are gathering this data from a text field and  placing in a variable 
of type string
then using that variable in the insert statement it may be rejected 
because it is not
type decimal. This  has been my experience with trying to get input 
data from

user's textfields and placing in the db.

dana.


Thanks Steve,

Actually I do not insert text data into my numeric field.
As I mentioned given
create table t1 { name text, cost decimal }
then I would like to insert numeric data into column cost because 
then I can later benefit from numerical operators like SUM, AVG, etc


More specifically, I am using HTML, Perl and PG. So from the HTML 
point of view a textfield is just some strings. So my user would 
enter 12345 but expressed in UTF8. Perl would get this and use DBI to 
insert it into PG


What I am experiencing now is that DB errors that I am trying to 
insert an incorrect data into column cost which is numeric and the 
data is coming in from HTML in UTF8


Mybe I have to convert it to ASCII numbers in Perl before inserting  
them into PG


Thanks
Medi


I understand PG supports UTF-8 encoding and I have sucessfully
inserted
Unicode text into columns. I was wondering about other data types such
as
numbers, decimal, dates

That is, say I have a table t1 with
create table t1 { name text, cost decimal }
I can insert UTF8 text datatype into this table with no problem
But if my application attempts to insert numbers encloded in UTF8,
then I
get wrong datatype error

Is the solution for the application layer (not database) to convert
the
non-text UTF8 numbers to ASCII and then insert it into database ?

Thanks
Medi

Hi Medi,

I have only limited experience in this area, but it sounds like you
sending your numbers as strings? In your example:

create table t1 { name text, cost decimal };

insert into t1 (name, cost) values ('name1', '1');

I can't think of how else you're sending numeric values as UTF8? I know
that Pg will accept numbers as strings and convert internally (that has
worked for me in some object relational environments where I don't
choose to cope with data types), but I think it would be better if you
simply didn't send your numeric data in quotations, whether as UTF8 or
ASCII. If you don't have control over this layer (that quotes your
values), then I'd say converting to ASCII would solve the problem. But
better to convert to numeric and not ship quoted strings at all.

I may be totally off-base and missing something fundamental and I'm
very open to correction (by anyone), but that's what I can see here.

Best regards,

Steve




---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

[jboss-user] [JBoss Seam] - easy alternatives to ui:repeat and c:forEach for Seam 1.2.0P

[dmp]

I have had nothing but trouble with ui:repeat, as it stops repeating on a 
regular basis and only show a single result until the app server was restarted. 
   c:forEach seemed reasonable, but it is way, way slow compared to ui:repeat.  
 I am not rendering a table, so h:dataTable wouldn't work for me, are there 
other easy/good solutions to this?  

tia,
Doug

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4038011#4038011

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4038011
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[Savannah-hackers-public] Unix Admin wanted for Savannah Administration

[dmp]

Hello,
Looks like the post for a Unix admin is still listed after a year so it
must still
be active. Perhaps I could donate some time to the site's needs. I have
a couple
of open source GNU projects. I came upon your site while doing a little
marketing
for one of the projects. I have seriously considered hosting the latest
over on
Savannah. I have several years experience working with many different
OS including
Unix/Linux. I'm not sure exacting how the first two requirements listed
are
accomplished though, besides some basic research or creating a project.

danap.


  

  Skill
  Level
  Experience


  GNU Coding Standards
  Base Knowledge
  6 Mo - 2 yr


  Software Licensing
  Base Knowledge
  6 Mo - 2 yr


  GNU/Linux
  Good Knowledge
  6 Mo - 2 yr

  

  

[jboss-user] [JBoss Seam] - Re: Seam 1.2 released

[dmp]

[EMAIL PROTECTED] wrote : Note that there is one silly minor issue in this 
release that you need an internet connection to run Seam. (We missed updating 
the version number of the DTD of the components.xml file in the Seam jar.)
  | 
  | We might do a patch release to fix this, but anyhoo it is fixed in CVS. 


For us home gamers that want to play along (and stick the fix in the jar), is 
this the fix in CVS you are referring to?

anonymous wrote : 
  | /jboss-seam/src/main/org/jboss/seam/components-1.2.dtd 
  | 1.1   by nrichards (19 hours ago) (+39) new 
  | in changeset MAIN:nrichards:20070227065100 

change xsd versions 
anonymous wrote : 
  | 
  | tia,
  | Doug

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4023430#4023430

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023430
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Seam] - Re: Seam 1.2 released

[dmp]

ooops.  Somehow ended up quoting the end of the message when I hit submit...  
Last quote was unintended.

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4023431#4023431

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023431
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Seam] - Re: Seam 1.2 released

[dmp]

Ah, it appears the updated dtd is in the jar, but when you explode 
jboss-seam.jar you'll find a components.xml under META-INF that references the 
1.1 version of the DTD.  :%s/1.1/1.2/g should hopefully have fixed this for me. 
 I'll find out soon enough.


View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4023435#4023435

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023435
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Seam] - Re: Seam 1.2 released

[dmp]

Based on the stack trace below, I don't think my little hack worked.  Since the 
this server running this code sits behind a fairly restrictive proxy, how can I 
fix this problem?

tia,
-Doug

Exception during request processing: org.dom4j.DocumentException: Connection 
timed out: connect Nested exception: Connection timed out: connect 
  | org.dom4j.io.SAXReader.read(SAXReader.java:484)
  | org.dom4j.io.SAXReader.read(SAXReader.java:343)
  | org.jboss.seam.util.XML.getRootElement(XML.java:16)
  | org.jboss.seam.core.Pages.getDocumentRoot(Pages.java:791)
  | org.jboss.seam.core.Pages.parse(Pages.java:781)
  | org.jboss.seam.core.Pages.createPage(Pages.java:172)
  | org.jboss.seam.core.Pages.getPage(Pages.java:147)
  | org.jboss.seam.core.Pages.createPageStack(Pages.java:229)
  | org.jboss.seam.core.Pages.getPageStack(Pages.java:208)
  | org.jboss.seam.core.Pages.applyRequestParameterValues(Pages.java:593)
  | 
org.jboss.seam.jsf.AbstractSeamPhaseListener.beforeRender(AbstractSeamPhaseListener.java:176)
  | org.jboss.seam.jsf.SeamPhaseListener.beforePhase(SeamPhaseListener.java:57)
  | 
org.apache.myfaces.lifecycle.PhaseListenerManager.informPhaseListenersBefore(PhaseListenerManager.java:70)
  | org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:373)
  | javax.faces.webapp.FacesServlet.service(FacesServlet.java:138)
  | 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
  | 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  | org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
  | 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  | 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  | org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
  | 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  | 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  | 
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  | 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  | 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  | 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
  | 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
  | 
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
  | 
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
  | 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
  | 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
  | 
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
  | 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
  | org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
  | org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
  | 
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
  | 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
  | 
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
  | java.lang.Thread.run(Thread.java:595)

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4023463#4023463

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023463
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[Ida-Krisna Show] Workshop Pembuatan Legal Opinion

[DMP Advocates]

WORKSHOP
 TEKNIK-TEKNIK YANG EFEKTIF DALAM PEMBUATAN LEGAL OPINION
 
 Pembicara: M. Yahya Harahap, SH.
 
 M. Yahya Harahap, SH adalah seorang praktisi hukum ternama yang telah bergelut di dunia hukum sejak tahun 1961. Pada tahun 1982 menjadi Hakim Agung pada Mahkamah Agung R.I dan tahun 1996 menjabat sebagai Ketua Muda Pidana Umum hingga pensiun pada tahun 2000. Berbagai buku hukum yang telah ditulisnya hingga menjadi referensi bagi para praktisi hukum lainnya yaitu:
 
 
 Arbitrase (1991) 
 Beberapa Tinjauan Mengenai Sistem Peradilan dan Penyelesaian Sengketa (1997) 
 Beberapa Tinjauan tentang Permasalahan Hukum, Buku 1 dan 2 (1997) 
 Hukum Acara Perdata tentang Gugatan, Persidangan, Penyitaan, Pembuktian dan Putusan Pengadilan (2005) 
 Perlawanan terhadap Eksekusi Grosse Akta serta Putusan pengadilan dan Arbitrase dan Standar Hukum Eksekusi (1996) 
 Ruang Lingkup Permasalahan Eksekusi di Bidang Perdata (1989) 
 Segi-Segi Hukum Perjanjian (1982) 
 Tinjauan Merk secara Umum dan Hukum Merk di Indonesia Berdasarkan Undang-Undang Nomor 19 Tahun 1992 (1996) 
 Dsb
 
 Pada kesempatan workshop ini, M. Yahya Harahap, SH akan menjelaskan secara detail dan terperinci bagaimana teknik-teknik yang efektif dalam membuat sebuah Legal Opinion bagi para praktisi hukum baik dalam bidang Litigasi maupun Corporate.
 
 Tempat: Candi Dieng, 2nd Floor
 Hotel Sahid Jaya Jakarta
 Jl. Jenderal Sudirman Jakarta
 
 Waktu : 09.30 – 15.00 wib
 
 Hari / Tanggal: Rabu / 14 Juni 2006
 
 Investasi: Rp 750.000,- (tujuh ratus lima puluh ribu rupiah)
 Pendaftaran ditutup tanggal 9 Juni 2006
 
 Pendaftaran:
 
 Mengisi Formulir Pendaftaran; 
 Melakukan pembayaran investasi melalui transfer rekening BCA
 a.c: 342-1657317
 a.n: R.A Shanti Dewi
 
 Segera kirimkan formulir pendaftaran dan bukti transfer melalui Faksimili: (021) 52900679 atau (021) 5251579
 email: [EMAIL PROTECTED]
 
 Panitia akan melakukan konfirmasi melalui telepon atau email kepada anda, jika formulir pendaftaran dan bukti transfer telah diterima;
 
 Informasi:
 
 Dewi Mulyaraharjani  Partners Advocates
 Patra Office Tower 3rd Floor, Room 307
 Jl. Jend. Gatot Subroto Kav. 32-34
 Jakarta
 Telepon: (021) 52900680
 Faksimili: (021) 52900679
 
 Harys  Partner Law Firm
 Patra Office Tower, 3rd Floor, Room 305
 Jl. Jend. Gatot Subroto Kav. 32-34
 Jakarta
 Telepon: (021) 5250116
 Faksimili: (021) 5251579
 
 Contact Person:
 Poni: (021) 52900680
 Arlan: (021) 5251579

__
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam 
http://id.mail.yahoo.com 

[Non-text portions of this message have been removed]









=
Morning greetings doesn't only mean saying 'Good Morning'.
It has silent message saying that I remember you when I wake up.
Wish you have a Great Day! -- Ida Arimurti

Jangan lupa simak IDA KRISNA SHOW SENIN HINGGA JUMAT di 99,1 DELTA FM
Jam 4 sore hingga 8 malam dan kirim sms di 0818 333 582.

=









  
  
SPONSORED LINKS
  
  
  

Station
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "idakrisnashow" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Ida-Krisna Show] Seminar Putusan Mahkamah Konstitusi - UU Ketenagakerjaan

[DMP Advocates]

Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) mengadakan kegiatan seminar nasional dengan topik"Implikasi Putusan Mahkamah Konstitusi tentang Pembatalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan"Yang akan diselenggarakan pada:Hari/tanggal : Rabu / 14 Desember 2005  Jam : 08.30 - 16.00 WIB  Tempat : Hotel Le Meridien, Jl.
 Jend. Sudirman Kav. 18-20Jakarta PusatDalam seminar ini akan menghadirkan 6 narasumber (pakar yang kompeten) dan akan membahas putusan MK dan UU Ketenagakerjaan dari berbagai perspektif:1. Prof. Dr. Sri Soemantri (Pakar Hukum Tata Negara)   Topik: Perkembangan Dunia Usaha dan PembangunanKetenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topik: Langkah-Langkah dan Kebijakan
 Pemerintah dalamMenyikapi Putusan MK tentang UU Ketenagakerjaan  3.Frans Hendra Winarta, S.H., M.H.(Advokat / Pemerhati Hukum)   Topik: Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari   Tinjauan HAM  4. Prof. Dr. A. Uwiyono, S.H. (Akademisi/Pengajar Hukum PerburuhanPasca Sarjana FHUI)   Topik: Menyeimbangkan Kepentingan Pengusaha dan Pekerjadalam UU Ketenagakerjaan Pasca Putusan MK  5. Soegeng Sarjadi (Ketua Soegeng Sarjadi Syndicate)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Dunia Usaha dan Pengusaha  6. Anwar Ma'ruf (Ketua Umum Kongres Aliansi Serikat BuruhIndonesia)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Pekerja / BuruhModerator:  - Irianto Subiakto, SH., LLM (KRHN)  - Shanti Dewi SH., MH. (Praktisi Hukum)Biaya investasi seminar Rp 1.500.000,- (satu juta lima ratus ribu rupiah) per
 person.Tempat terbatas dan pendaftaran ditutup tanggal 10 Desember 2005.Pendaftaran hubungi:  Poni (DMP Advocates): 021-52900680  Fitri atau Yulianti (KRHN): 021-3928384  Email: [EMAIL PROTECTED]Satu perusahaan yang mengirimkan 3 peserta mendapat discount 20%.__Apakah Anda Yahoo!?Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam  http://id.mail.yahoo.com 





=
Morning greetings doesn't only mean saying 'Good Morning'.
It has silent message saying that I remember you when I wake up.
Wish you have a Great Day! -- Ida  Krisna

Jangan lupa untuk selalu menyimak Ida Krisna Show di 99.1 DeltaFM
Senin - Jumat, pukul 06.00 - 10.00 WIB
SMS di 0818-333582
=






  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "idakrisnashow" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Ida-Krisna Show] Seminar Putusan Mahkamah Konstitusi - UU Ketenagakerjaan

[DMP Advocates]

Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) mengadakan kegiatan seminar nasional dengan topik"Implikasi Putusan Mahkamah Konstitusi tentang Pembatalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan"Yang akan diselenggarakan pada:Hari/tanggal : Rabu / 14 Desember 2005  Jam : 08.30 - 16.00 WIB  Tempat : Hotel Le Meridien, Jl.
 Jend. Sudirman Kav. 18-20Jakarta PusatDalam seminar ini akan menghadirkan 6 narasumber (pakar yang kompeten) dan akan membahas putusan MK dan UU Ketenagakerjaan dari berbagai perspektif:1. Prof. Dr. Sri Soemantri (Pakar Hukum Tata Negara)   Topik: Perkembangan Dunia Usaha dan PembangunanKetenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topik: Langkah-Langkah dan Kebijakan
 Pemerintah dalamMenyikapi Putusan MK tentang UU Ketenagakerjaan  3.Frans Hendra Winarta, S.H., M.H.(Advokat / Pemerhati Hukum)   Topik: Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari   Tinjauan HAM  4. Prof. Dr. A. Uwiyono, S.H. (Akademisi/Pengajar Hukum PerburuhanPasca Sarjana FHUI)   Topik: Menyeimbangkan Kepentingan Pengusaha dan Pekerjadalam UU Ketenagakerjaan Pasca Putusan MK  5. Soegeng Sarjadi (Ketua Soegeng Sarjadi Syndicate)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Dunia Usaha dan Pengusaha  6. Anwar Ma'ruf (Ketua Umum Kongres Aliansi Serikat BuruhIndonesia)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Pekerja / BuruhModerator:  - Irianto Subiakto, SH., LLM (KRHN)  - Shanti Dewi SH., MH. (Praktisi Hukum)Biaya investasi seminar Rp 1.500.000,- (satu juta lima ratus ribu rupiah) per
 person.Tempat terbatas dan pendaftaran ditutup tanggal 10 Desember 2005.Pendaftaran hubungi:  Poni (DMP Advocates): 021-52900680  Fitri atau Yulianti (KRHN): 021-3928384  Email: [EMAIL PROTECTED]Satu perusahaan yang mengirimkan 3 peserta mendapat discount 20%, berlaku sampai tanggal 30 November 2005.__Apakah Anda Yahoo!?Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam 
 http://id.mail.yahoo.com 





=
Morning greetings doesn't only mean saying 'Good Morning'.
It has silent message saying that I remember you when I wake up.
Wish you have a Great Day! -- Ida  Krisna

Jangan lupa untuk selalu menyimak Ida Krisna Show di 99.1 DeltaFM
Senin - Jumat, pukul 06.00 - 10.00 WIB
SMS di 0818-333582
=









  
  
SPONSORED LINKS
  
  
  

Radio station advertising
  
  
Satellite radio stations
  
  
Cb radio base station
  
  


Weather radio station
  
  
Radio station promotion
  
  
Christian radio station
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "idakrisnashow" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Ida-Krisna Show] (unknown)

[DMP Advocates]

Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) mengadakan kegiatan seminar nasional dengan topik"Implikasi Putusan Mahkamah Konstitusi tentang Pembaalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan"Yang akan diselenggarakan pada:Hari/tanggal : Rabu / 14 Desember 2005  Jam : 08.30 - 16.00 WIB  Tempat : Hotel Le Meridien, Jl.
 Jend. Sudirman Kav. 18-20Jakarta PusatDalam seminar ini akan menghadirkan 6 narasumber (pakar yang kompeten) dan akan membahas putusan MK dan UU Ketenagakerjaan dari berbagai perspektif:1. Prof. Dr. Sri Soemantri (Pakar Hukum Tata Negara)   Topik: Perkembangan Dunia Usaha dan PembangunanKetenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topik: Langkah-Langkah dan Kebijakan
 Pemerintah dalamMenyikapi Putusan MK tentang UU Ketenagakerjaan  3.Frans Hendra Winarta, S.H., M.H.(Advokat / Pemerhati Hukum)   Topik: Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari   Tinjauan HAM  4. Prof. Dr. A. Uwiyono, S.H. (Akademisi/Pengajar Hukum PerburuhanPasca Sarjana FHUI)   Topik: Menyeimbangkan Kepentingan Pengusaha dan Pekerjadalam UU Ketenagakerjaan Pasca Putusan MK  5. Soegeng Sarjadi (Ketua Soegeng Sarjadi Syndicate)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Dunia Usaha dan Pengusaha  6. Anwar Ma'ruf (Ketua Umum Kongres Aliansi Serikat BuruhIndonesia)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Pekerja / BuruhModerator:  - Irianto Subiakto, SH., LLM (KRHN)  - Shanti Dewi SH., MH. (Praktisi Hukum)Biaya investasi seminar Rp 1.500.000,- (satu juta lima ratus ribu rupiah) per
 person.Tempat terbatas dan pendaftaran ditutup tanggal 10 Desember 2005.Pendaftaran hubungi:  Poni (DMP Advocates): 021-52900680  Fitri atau Yulianti (KRHN): 021-3928384  Email: [EMAIL PROTECTED]Satu perusahaan yang mengirimkan 3 peserta mendapat discount 20%, berlaku sampai tanggal 30 November 2005.__Apakah Anda Yahoo!?Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam  http://id.mail.yahoo.com 





=
Morning greetings doesn't only mean saying 'Good Morning'.
It has silent message saying that I remember you when I wake up.
Wish you have a Great Day! -- Ida  Krisna

Jangan lupa untuk selalu menyimak Ida Krisna Show di 99.1 DeltaFM
Senin - Jumat, pukul 06.00 - 10.00 WIB
SMS di 0818-333582
=









  
  
SPONSORED LINKS
  
  
  

Radio station advertising
  
  
Satellite radio stations
  
  
Cb radio base station
  
  


Weather radio station
  
  
Radio station promotion
  
  
Christian radio station
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "idakrisnashow" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Ida-Krisna Show] Seminar Putusan Mahkamah Konstitusi - UU Ketenagakerjaan

[DMP Advocates]

Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) mengadakan kegiatan seminar nasional dengan topik"Implikasi Putusan Mahkamah Konstitusi tentang Pembaalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan"Yang akan diselenggarakan pada:Hari/tanggal : Rabu / 14 Desember 2005  Jam : 08.30 - 16.00 WIB  Tempat : Hotel Le Meridien, Jl.
 Jend. Sudirman Kav. 18-20Jakarta PusatDalam seminar ini akan menghadirkan 6 narasumber (pakar yang kompeten) dan akan membahas putusan MK dan UU Ketenagakerjaan dari berbagai perspektif:1. Prof. Dr. Sri Soemantri (Pakar Hukum Tata Negara)   Topik: Perkembangan Dunia Usaha dan PembangunanKetenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topik: Langkah-Langkah dan Kebijakan
 Pemerintah dalamMenyikapi Putusan MK tentang UU Ketenagakerjaan  3.Frans Hendra Winarta, S.H., M.H.(Advokat / Pemerhati Hukum)   Topik: Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari   Tinjauan HAM  4. Prof. Dr. A. Uwiyono, S.H. (Akademisi/Pengajar Hukum PerburuhanPasca Sarjana FHUI)   Topik: Menyeimbangkan Kepentingan Pengusaha dan Pekerjadalam UU Ketenagakerjaan Pasca Putusan MK  5. Soegeng Sarjadi (Ketua Soegeng Sarjadi Syndicate)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Dunia Usaha dan Pengusaha  6. Anwar Ma'ruf (Ketua Umum Kongres Aliansi Serikat BuruhIndonesia)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Pekerja / BuruhModerator:  - Irianto Subiakto, SH., LLM (KRHN)  - Shanti Dewi SH., MH. (Praktisi Hukum)Biaya investasi seminar Rp 1.500.000,- (satu juta lima ratus ribu rupiah) per
 person.Tempat terbatas dan pendaftaran ditutup tanggal 10 Desember 2005.Pendaftaran hubungi:  Poni (DMP Advocates): 021-52900680  Fitri atau Yulianti (KRHN): 021-3928384  Email: [EMAIL PROTECTED]Satu perusahaan yang mengirimkan 3 peserta mendapat discount 20%, berlaku sampai tanggal 30 November 2005.__Apakah Anda Yahoo!?Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam  http://id.mail.yahoo.com 





=
Morning greetings doesn't only mean saying 'Good Morning'.
It has silent message saying that I remember you when I wake up.
Wish you have a Great Day! -- Ida  Krisna

Jangan lupa untuk selalu menyimak Ida Krisna Show di 99.1 DeltaFM
Senin - Jumat, pukul 06.00 - 10.00 WIB
SMS di 0818-333582
=









  
  
SPONSORED LINKS
  
  
  

Radio station advertising
  
  
Satellite radio stations
  
  
Cb radio base station
  
  


Weather radio station
  
  
Radio station promotion
  
  
Christian radio station
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "idakrisnashow" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Ida-Krisna Show] Seminar Putusan Mahkamah Konstitusi - UU Ketenagakerjaan

[DMP Advocates]

Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) mengadakan kegiatan seminar nasional dengan topik"Implikasi Putusan Mahkamah Konstitusi tentang Pembaalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan"Yang akan diselenggarakan pada:Hari/tanggal : Rabu / 14 Desember 2005  Jam : 08.30 - 16.00 WIB  Tempat : Hotel Le Meridien, Jl. Jend. Sudirman Kav. 18-20  
  Jakarta PusatDalam seminar ini akan menghadirkan 6 narasumber (pakar yang kompeten) dan akan membahas putusan MK dan UU Ketenagakerjaan dari berbagai perspektif:1. Prof. Dr. Sri Soemantri (Pakar Hukum Tata Negara)   Topik: Perkembangan Dunia Usaha dan PembangunanKetenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topik: Langkah-Langkah dan Kebijakan Pemerintah dalam  
  Menyikapi Putusan MK tentang UU Ketenagakerjaan  3. Abdul Hakim Garuda Nusantara, SH (Advokat / Pemerhati Hukum)*   Topik: Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari   Tinjauan HAM  4. Prof. Dr. A. Uwiyono, S.H. (Akademisi/Pengajar Hukum PerburuhanPasca Sarjana FHUI)   Topik: Menyeimbangkan Kepentingan Pengusaha dan Pekerjadalam UU Ketenagakerjaan Pasca Putusan MK  5. Erick Thohir (Direktur Utama P.T. Mahaka Media)*   Topik: Implikasi Putusan MK
 tentang UU Ketenagakerjaan BagiKepentingan Dunia Usaha dan Pengusaha  6. Anwar Ma'ruf (Ketua Umum Kongres Aliansi Serikat BuruhIndonesia)   Topik: Implikasi Putusan MK tentang UU Ketenagakerjaan BagiKepentingan Pekerja / BuruhModerator:  - Irianto Subiakto, SH., LLM (KRHN)  - Shanti Dewi SH., MH. (Praktisi Hukum)Biaya investasi seminar Rp 1.500.000,- (satu juta lima ratus ribu rupiah) per person.  
  Tempat terbatas dan pendaftaran ditutup tanggal 10 Desember 2005.Pendaftaran hubungi:  Poni (DMP Advocates): 021-52900680  Fitri atau Yulianti (KRHN): 021-3928384  Email: [EMAIL PROTECTED]  __Apakah Anda Yahoo!?Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam  http://id.mail.yahoo.com 





=
Morning greetings doesn't only mean saying 'Good Morning'.
It has silent message saying that I remember you when I wake up.
Wish you have a Great Day! -- Ida  Krisna

Jangan lupa untuk selalu menyimak Ida Krisna Show di 99.1 DeltaFM
Senin - Jumat, pukul 06.00 - 10.00 WIB
SMS di 0818-333582
=






  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "idakrisnashow" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Ida-Krisna Show] Putusan Mahkamah Konstitusi Yang Membatalkan Pasal PHK Dalam UU Ketenagakerjaan

[DMP Advocates]

  Pada tanggal 28 Oktober 2004 Mahkamah Konstitusi (MK) Republik Indonesia mengeluarkan putusan perkara Nomor: 012/PUU-1/2003 tentang permohonan pengujian UU No. 13 tahun 2003 tentang Ketenagakerjaan. Dalam
 salah satu putusannya MK menyatakanbahwa pasal 158 dan pasal 159 Undang-Undang Ketenagakerjaan dinyatakan bertentangan dengan Undang-Undang Dasar Negara Republik Indonesia Tahun 1945 dan tidak mempunyai kekuatan hukum mengikat. Dalam putusan ini, MK juga membatalkan bunyi anak kalimat yang terkait di dalam pasal 160 (1), pasal 170 dan pasal 171 UU Ketenagakerjaan.Jika dilihat bunyi pasal 158 Undang-Undang
 Ketenagakerjaan, mengatur tentang pemutusan hubungan kerja yang dilakukan oleh pengusaha dengan alasan pekerja/buruh telah melakukan kesalahan berat seperti, mencuri, penggelapan barang, mabuk, perbuatan asusila, membocorkan rahasia perusahaan dan sebagainya. Kesalahan berat itu harus didukung dengan bukti tertangkap tangan, ada pengakuan dan bukti lain dari pihak yang berwenang di perusahaan dengan didukung 2 orang saksi. Sedangkan pasal 159 mengatur apabila pekerja/buruh tidak menerima pemutusan hubungan kerja sebagaimana dimaksud, dapat mengajukan gugatan ke lembaga penyelesaian hubungan industrial. Majelis Hakim MK mempertimbangkan bahwa pasal 158 telah memberi kewenangan pada pengusaha untuk melakukan PHK dengan alasan buruh/pekerja telah melakukan kesalahan berat tanpa due process of law melalui putusan pengadilan yang independen dan imparsial, melainkan cukup hanya dengan keputusan pengusaha yang didukung oleh bukti-bukti yang tidak perlu diuji keabsahannya menurut hukum acara yang berlaku. Pasal 158 ini bertentangan dengan Pasal 27 ayat (1) UUD 1945 bahwa Segala Warga Negara bersamaan kedudukannya dalam hukum dan pemerintahan dan wajib menjunjung hukum dan pemerintahan dengan tidak ada kecualinya. Hal ini dipandang sebagai perlakuan diskriminatif yang bertentangan dengan UUD 1945. Sedangkan terhadap ketentuan pasal 159, Majelis Hakim MK beranggapan bahwa ketentuan tersebut disamping melahirkan beban pembuktian yang tidak adil dan berat bagi buruh/pekerja untuk membuktikan ketidaksalahannya, sebagai pihak yang secara ekonomis lebih lemah yang seharusnya memperoleh perlindungan hukum yang lebih dibanding pengusaha, pasal 159 ini juga telah menimbulkan kerancuan berpikir dengan mencampuradukkan proses perkara pidana dengan perkara perdata secara tidak pada tempatnya. Mencermati putusan itu muncul beberapa pertanyaan, apa implikasi yang ditimbulkan dari putusan MK tersebut? Bagaimana respon dan langkah-langkah yang diambil pemerintah dan khususnya dunia usaha menyikapi putusan MK. Apa landasan hukum yang bisa digunakan pengusaha jika ternyata pekerja/buruh melakukan kesalahan berat sebagaimana diatur sebelumnya dalam pasal 158 (1) UU Ketenagakerjaan. Apakah putusan MK itu merugikan kepentingan pengusaha dan menguntungkan posisi pekerja/buruh atau sebaliknya? Atau justru keduanya yang dirugikan karena disatu sisi pekerja/buruh akan melalui proses hukum pidana yang panjang dan terkadang melelahkan. Sedangkan bagi pengusaha harus menunggu putusan pengadilan yang mempunyai kekuatan hukum tetap sebelum memutuskan hubungan kerja karena alasan melakukan kesalahan berat.Berdasarkan pemaparan tersebut diatas, kami Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) akan mengadakan kegiatan Seminar Nasional “Implikasi Putusan Mahkamah Konstitusi tentang Pembatalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan”. Seminar ini sebagai upaya untuk melihat dan mengkaji lebih jauh akan putusan MK dan implikasi yang ditimbulkan. Sekaligus merupakan upaya sosialisasi kepada pengusaha dan pekerja/buruh/karyawan atas putusan Mahkamah Konstitusi. Mengingat betapa pentingnya putusan MK ini untuk diketahui oleh masyarakat, khususnya bagi kalangan dunia usaha, pekerja/buruh dan praktisi hukum (advokat).Seminar Nasional tentang Implikasi Putusan Mahkamah Konstitusi Tentang Pembatalan Pasal Pemutusan Hubungan Kerja
 oleh Pengusaha Dalam UU Ketenagakerjaan ini akan diselenggarakan pada:Hari / Tanggal  : Rabu / 14 Desember 2005  Jam  : 08.30 – 16.00
 WIB  Tempat : Hotel Le Meridien, Jl. Jend. Sudirman Kav.18- 20 Jakarta PusatDalam
 Seminar ini akan menghadirkan 6 orang narasumber (pakar) yang kompeten dan akan membahas putusan MK dari berbagai perspektif :  1. Prof. Dr. Sri Soemantri, S.H., (Pakar Hukum Tata Negara)  Topic : Perkembangan Dunia Usaha dan Pembangunan Ketenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topic : Langkah-Langkah dan Kebijakan Pemerintah dalam Menyikapi Putusan MK tentang UU Ketenagakerjaan  3.Abdul Hakim Garuda Nusantara, SH (Advokat/Pemerhati Hukum) *  Topic : Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari Tinjauan HAM  4.Prof. Dr. Uwiyono S.H. (Akademisi/Pengajar Hukum Perburuhan Pasca

[Ida-Krisna Show] Putusan Mahkamah Konstitusi Yang Membatalkan Pasal PHK Dalam UU Ketenagakerjaan

[DMP Advocates]

  Pada tanggal 28 Oktober 2004 Mahkamah Konstitusi (MK) Republik Indonesia mengeluarkan putusan perkara Nomor: 012/PUU-1/2003 tentang permohonan pengujian UU No. 13 tahun 2003 tentang Ketenagakerjaan. Dalam salah satu putusannya MK
 menyatakanbahwa pasal 158 dan pasal 159 Undang-Undang Ketenagakerjaan dinyatakan bertentangan dengan Undang-Undang Dasar Negara Republik Indonesia Tahun 1945 dan tidak mempunyai kekuatan hukum mengikat. Dalam putusan ini, MK juga membatalkan bunyi anak kalimat yang terkait di dalam pasal 160 (1), pasal 170 dan pasal 171 UU Ketenagakerjaan.Jika dilihat bunyi pasal 158 Undang-Undang Ketenagakerjaan, mengatur tentang pemutusan hubungan
 kerja yang dilakukan oleh pengusaha dengan alasan pekerja/buruh telah melakukan kesalahan berat seperti, mencuri, penggelapan barang, mabuk, perbuatan asusila, membocorkan rahasia perusahaan dan sebagainya. Kesalahan berat itu harus didukung dengan bukti tertangkap tangan, ada pengakuan dan bukti lain dari pihak yang berwenang di perusahaan dengan didukung 2 orang saksi. Sedangkan pasal 159 mengatur apabila pekerja/buruh tidak menerima pemutusan hubungan kerja sebagaimana dimaksud, dapat mengajukan gugatan ke lembaga penyelesaian hubungan industrial. Majelis Hakim MK
 mempertimbangkan bahwa pasal 158 telah memberi kewenangan pada pengusaha untuk melakukan PHK dengan alasan buruh/pekerja telah melakukan kesalahan berat tanpa due process of law melalui putusan pengadilan yang independen dan imparsial, melainkan cukup hanya dengan keputusan pengusaha yang didukung oleh bukti-bukti yang tidak perlu diuji keabsahannya menurut hukum acara yang berlaku. Pasal 158 ini bertentangan dengan Pasal 27 ayat (1) UUD 1945 bahwa Segala Warga Negara bersamaan kedudukannya dalam hukum dan pemerintahan dan wajib menjunjung hukum dan pemerintahan dengan tidak ada kecualinya. Hal ini dipandang sebagai perlakuan diskriminatif yang bertentangan dengan UUD 1945. Sedangkan terhadap ketentuan pasal 159, Majelis Hakim MK beranggapan bahwa ketentuan tersebut disamping melahirkan beban pembuktian yang tidak adil dan berat bagi buruh/pekerja untuk membuktikan ketidaksalahannya, sebagai pihak yang secara ekonomis lebih lemah yang seharusnya memperoleh perlindungan hukum yang lebih dibanding pengusaha, pasal 159 ini juga telah menimbulkan kerancuan berpikir dengan mencampuradukkan proses perkara pidana dengan perkara perdata secara tidak pada tempatnya. Mencermati putusan itu muncul beberapa pertanyaan, apa implikasi yang ditimbulkan dari putusan MK tersebut? Bagaimana respon dan langkah-langkah yang diambil pemerintah dan khususnya dunia usaha menyikapi putusan MK. Apa landasan hukum yang bisa digunakan pengusaha jika ternyata pekerja/buruh melakukan kesalahan berat sebagaimana diatur sebelumnya dalam pasal 158 (1) UU Ketenagakerjaan. Apakah putusan MK itu merugikan kepentingan pengusaha dan menguntungkan posisi pekerja/buruh atau sebaliknya? Atau justru keduanya yang dirugikan karena disatu sisi pekerja/buruh akan melalui proses hukum pidana yang panjang dan terkadang melelahkan. Sedangkan bagi pengusaha harus menunggu putusan pengadilan yang mempunyai kekuatan hukum tetap sebelum memutuskan hubungan kerja karena alasan melakukan kesalahan berat.Berdasarkan pemaparan tersebut diatas, kami Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) akan mengadakan kegiatan Seminar Nasional “Implikasi Putusan Mahkamah Konstitusi tentang Pembatalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan”. Seminar ini sebagai upaya untuk melihat dan mengkaji lebih jauh akan putusan MK dan implikasi yang ditimbulkan. Sekaligus merupakan upaya sosialisasi kepada pengusaha dan pekerja/buruh/karyawan atas putusan Mahkamah Konstitusi. Mengingat betapa pentingnya putusan MK ini untuk diketahui oleh masyarakat, khususnya bagi kalangan dunia usaha, pekerja/buruh dan praktisi hukum (advokat).Seminar Nasional tentang Implikasi Putusan Mahkamah Konstitusi Tentang Pembatalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU
 Ketenagakerjaan ini akan diselenggarakan pada:Hari / Tanggal  : Rabu / 14 Desember 2005  Jam  : 08.30 – 16.00 WIB
  Tempat : Hotel Le Meridien, Jl. Jend. Sudirman Kav.18- 20 Jakarta PusatDalam Seminar ini akan
 menghadirkan 6 orang narasumber (pakar) yang kompeten dan akan membahas putusan MK dari berbagai perspektif :  1. Prof. Dr. Sri Soemantri, S.H., (Pakar Hukum Tata Negara)  Topic : Perkembangan Dunia Usaha dan Pembangunan Ketenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topic : Langkah-Langkah dan Kebijakan Pemerintah dalam Menyikapi Putusan MK tentang UU Ketenagakerjaan  3.Abdul Hakim Garuda Nusantara, SH (Advokat/Pemerhati Hukum) *  Topic
 : Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari Tinjauan HAM  4.Prof. Dr. Uwiyono S.H. (Akademisi/Pengajar Hukum Perburuhan Pasca

[Ida-Krisna Show] Putusan Mahkamah Konstitusi Yang Membatalkan Pasal PHK Dalam UU Ketenagakerjaan

[DMP Advocates]

Pada tanggal 28 Oktober 2004 Mahkamah Konstitusi (MK) Republik Indonesia mengeluarkan putusan perkara Nomor: 012/PUU-1/2003 tentang permohonan pengujian UU No. 13 tahun 2003 tentang Ketenagakerjaan. Dalam salah satu
 putusannya MK menyatakanbahwa pasal 158 dan pasal 159 Undang-Undang Ketenagakerjaan dinyatakan bertentangan dengan Undang-Undang Dasar Negara Republik Indonesia Tahun 1945 dan tidak mempunyai kekuatan hukum mengikat. Dalam putusan ini, MK juga membatalkan bunyi anak kalimat yang terkait di dalam pasal 160 (1), pasal 170 dan pasal 171 UU Ketenagakerjaan.Jika dilihat bunyi pasal 158 Undang-Undang
 Ketenagakerjaan, mengatur tentang pemutusan hubungan kerja yang dilakukan oleh pengusaha dengan alasan pekerja/buruh telah melakukan kesalahan berat seperti, mencuri, penggelapan barang, mabuk, perbuatan asusila, membocorkan rahasia perusahaan dan sebagainya. Kesalahan berat itu harus didukung dengan bukti tertangkap tangan, ada pengakuan dan bukti lain dari pihak yang berwenang di perusahaan dengan didukung 2 orang saksi. Sedangkan pasal 159 mengatur apabila pekerja/buruh tidak menerima pemutusan hubungan kerja sebagaimana dimaksud, dapat mengajukan gugatan ke lembaga penyelesaian hubungan industrial. Majelis Hakim MK mempertimbangkan bahwa pasal 158 telah memberi kewenangan pada pengusaha untuk melakukan PHK dengan alasan buruh/pekerja telah melakukan kesalahan berat tanpa due process of law melalui putusan pengadilan yang independen dan imparsial, melainkan cukup hanya dengan keputusan pengusaha yang didukung oleh bukti-bukti yang tidak perlu diuji keabsahannya menurut hukum acara yang berlaku. Pasal 158 ini bertentangan dengan Pasal 27 ayat (1) UUD 1945 bahwa Segala Warga Negara bersamaan kedudukannya dalam hukum dan pemerintahan dan wajib menjunjung hukum dan pemerintahan dengan tidak ada kecualinya. Hal ini dipandang sebagai perlakuan diskriminatif yang bertentangan dengan UUD 1945. Sedangkan terhadap ketentuan pasal 159, Majelis Hakim MK beranggapan bahwa ketentuan tersebut disamping melahirkan beban pembuktian yang tidak adil dan berat bagi buruh/pekerja untuk membuktikan ketidaksalahannya, sebagai pihak yang secara ekonomis lebih lemah yang seharusnya memperoleh perlindungan hukum yang lebih dibanding pengusaha, pasal 159 ini juga telah menimbulkan kerancuan berpikir dengan mencampuradukkan proses perkara pidana dengan perkara perdata secara tidak pada tempatnya. Mencermati putusan itu muncul beberapa pertanyaan, apa implikasi yang ditimbulkan dari putusan MK tersebut? Bagaimana respon dan langkah-langkah yang diambil pemerintah dan khususnya dunia usaha menyikapi putusan MK. Apa landasan hukum yang bisa digunakan pengusaha jika ternyata pekerja/buruh melakukan kesalahan berat sebagaimana diatur sebelumnya dalam pasal 158 (1) UU Ketenagakerjaan. Apakah putusan MK itu merugikan kepentingan pengusaha dan menguntungkan posisi pekerja/buruh atau sebaliknya? Atau justru keduanya yang dirugikan karena disatu sisi pekerja/buruh akan melalui proses hukum pidana yang panjang dan terkadang melelahkan. Sedangkan bagi pengusaha harus menunggu putusan pengadilan yang mempunyai kekuatan hukum tetap sebelum memutuskan hubungan kerja karena alasan melakukan kesalahan berat.Berdasarkan pemaparan tersebut diatas, kami Konsorsium Reformasi Hukum Nasional (KRHN) bekerja sama dengan Kantor Advokat Dewi Mulyaraharjani  Partners (DMP Advocates) akan mengadakan kegiatan Seminar Nasional “Implikasi Putusan Mahkamah Konstitusi tentang Pembatalan Pasal Pemutusan Hubungan Kerja oleh Pengusaha Dalam UU Ketenagakerjaan”. Seminar ini sebagai upaya untuk melihat dan mengkaji lebih jauh akan putusan MK dan implikasi yang ditimbulkan. Sekaligus merupakan upaya sosialisasi kepada pengusaha dan pekerja/buruh/karyawan atas putusan Mahkamah Konstitusi. Mengingat betapa pentingnya putusan MK ini untuk diketahui oleh masyarakat, khususnya bagi kalangan dunia usaha, pekerja/buruh dan praktisi hukum (advokat).Seminar Nasional tentang Implikasi Putusan Mahkamah Konstitusi Tentang Pembatalan Pasal Pemutusan Hubungan Kerja
 oleh Pengusaha Dalam UU Ketenagakerjaan ini akan diselenggarakan pada:Hari / Tanggal  : Rabu / 14 Desember 2005  Jam  : 08.30 – 16.00
 WIB  Tempat : Hotel Le Meridien, Jl. Jend. Sudirman Kav.18- 20 Jakarta PusatDalam
 Seminar ini akan menghadirkan 6 orang narasumber (pakar) yang kompeten dan akan membahas putusan MK dari berbagai perspektif :  1. Prof. Dr. Sri Soemantri, S.H., (Pakar Hukum Tata Negara)  Topic : Perkembangan Dunia Usaha dan Pembangunan Ketenagakerjaan dalam pandangan UUD 1945  2. Dr. Muzni Tambusai, Msc (Dirjen Perselisihan Hubungan Industrial)  Topic : Langkah-Langkah dan Kebijakan Pemerintah dalam Menyikapi Putusan MK tentang UU Ketenagakerjaan  3.Abdul Hakim Garuda Nusantara, SH (Advokat/Pemerhati Hukum) *  Topic : Pemutusan Hubungan Kerja (PHK) dalam Putusan MK dari Tinjauan HAM  4.Prof. Dr. Uwiyono S.H. (Akademisi/Pengajar Hukum Perburuhan Pasca

Re: cvs commit: src/sys/net80211 ieee80211.c ieee80211_input.c ieee80211_ioctl.c ieee80211_node.c ieee80211_node.h ieee80211_output.c ieee80211_proto.c ieee80211_proto.h ieee80211_var.h src/sys/dev/ath if_ath.c src/sys/dev/ipw if_ipw.c ...

[dmp]

Quoting Sam Leffler [EMAIL PROTECTED]:


The ipw and iwi drivers (at least) have never worked right so far as 
I can tell.  At one point I tried the iwi driver and it kinda worked 
but failed in many common scenarios and in general was very fragile.  
I no longer have the facilities to even test these drivers and given 
that I know of no cardbus cards w/ intel parts in them it's unlikely 
I ever will unless someone wants to donate a laptop dedicated to 
testing.


If you have a notebook with a MiniPCI slot, the Intel 2100, 2200 and 2915
MiniPCI cards can be had in the after-market for US$30 or less.


This message was sent using IMP, the Internet Messaging Program.

___
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to [EMAIL PROTECTED]