Re: [sqlite] Regarding CoC

2018-10-24 Thread 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

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

2018-10-20 Thread 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

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

2018-10-12 Thread 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

Re: [sqlite] Ajqvue v2.10 Released

2018-10-08 Thread 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

[sqlite] Ajqvue v2.10 Released

2018-10-07 Thread 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

Re: [sqlite] DB To DB Transfer Time

2018-10-03 Thread 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

Re: [sqlite] DB To DB Transfer Time

2018-10-02 Thread 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

Re: [sqlite] DB To DB Transfer Time

2018-09-26 Thread 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!

[sqlite] DB To DB Transfer Time

2018-09-25 Thread 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

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

2018-08-31 Thread 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

Re: [sqlite] Time Precision

2018-08-26 Thread 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

Re: [sqlite] The upcoming alter table rename column

2018-08-16 Thread 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

[sqlite] Ajqvue Version 2.0 Released

2018-08-06 Thread 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

Re: [sqlite] SQLite .dump

2018-07-14 Thread 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

[sqlite] SQLite .dump

2018-07-13 Thread 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:

[sqlite] (no subject)

2018-07-13 Thread 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

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

2018-07-12 Thread 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. >

[sqlite] Subject: Re: Date Search

2018-07-06 Thread 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

Re: [sqlite] Time Precision

2018-07-06 Thread 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',

[sqlite] Date Search

2018-07-05 Thread 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")

Re: [sqlite] Time Precision

2018-07-02 Thread 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.

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

2018-06-15 Thread 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

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

2018-06-03 Thread 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

[sqlite] Subject: Re: SQL Date Import

2018-06-02 Thread 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.

[sqlite] SQL Date Import

2018-06-01 Thread 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

Re: [sqlite] Size of the SQLite library

2018-06-01 Thread 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.

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

2018-05-31 Thread 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

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

2018-05-30 Thread 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

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

2018-05-28 Thread 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

Re: [sqlite] How to Handle BigInt

2018-05-03 Thread 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

Re: [sqlite] How to Handle BigInt

2018-05-02 Thread 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.

[sqlite] How to Handle BigInt

2018-05-01 Thread 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

Re: [sqlite] JDBC driver experience

2018-04-19 Thread 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

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

2018-04-15 Thread 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.

unsubscribe

2018-02-07 Thread dmp
unsubscribe - To unsubscribe e-mail: user-unsubscr...@spark.apache.org

Mail List Daily Archive

2018-01-16 Thread 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

2017-11-22 Thread 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

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

2017-11-14 Thread 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

Re: [sqlite] SQLite Port/ODBC Driver Question

2017-07-10 Thread 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

[sqlite] Subject: Re: sqlite with Java

2017-03-19 Thread 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

Re: [sqlite] confused getting started

2017-03-05 Thread 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 >

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

2017-01-06 Thread 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

Re: [sqlite] SQLite3 Tutorial error

2017-01-05 Thread 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

[sqlite] Ajqvue 1.11 Released

2016-12-10 Thread 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

[sqlite] Ajqvue Version 1.10 Released

2016-10-11 Thread 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

[sqlite] MyJSQLView Version 7.08 Released

2016-09-11 Thread 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

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

2016-09-07 Thread 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.

Re: [sqlite] SQL to SQLite

2016-07-21 Thread 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

Re: [sqlite] SQL to SQLite

2016-07-20 Thread 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

[ANNOUNCE] MyJSQLView Version 7.03 Released

2015-06-16 Thread 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

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

2015-03-30 Thread 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

[ANNOUNCE] MyJSQLView Version 3.48 Released

2014-03-13 Thread 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

[Trisquel-users] Wine on Trisquel 6.0

2013-12-25 Thread 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

[ANNOUNCE] MyJSQLView Verrsion 3.47 Released

2013-11-15 Thread 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

[ANNOUNCE] MyJSQLView Version 3.41 Released

2013-01-21 Thread 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,

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

2012-11-16 Thread 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

[ANNOUNCE] MyJSQLView Version 3.40 Released

2012-11-02 Thread 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

[ANNOUNCE] MyJSQLView Version 3.35 Released

2012-06-01 Thread 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

[ANNOUNCE] MyJSQLView Version 3.34 Released

2012-04-13 Thread 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

[ANNOUNCE] MyJSQLView Version 3.31 Released

2012-02-05 Thread 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

[sqlite] GROUP BY With ASC/DESC

2011-11-11 Thread 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

[sqlite] GROUP BY With ASC/DESC

2011-11-11 Thread 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

[ANNOUNCE] MyJSQLView Version 3.31 Released

2011-10-14 Thread 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

[ANNOUNCE] MyJSQLView Version 3.30 Released

2011-08-13 Thread 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.

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

2011-06-11 Thread dmp
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

[ANNOUNCE] MyJSQLView Version 3.26 Released

2011-03-23 Thread 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

[sqlite] MyJSQLView Version 3.23 Released

2010-09-23 Thread 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] MyJSQLView Version 3.23 Released

2010-09-23 Thread 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

[ANNOUNCE] MyJSQLView Version 3.23 Released

2010-09-21 Thread 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

[ANNOUNCE] MyJSQLView Version 3.22 Released

2010-07-21 Thread 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

[android-developers] Flash usage in android 2.2

2010-07-09 Thread 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

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

2010-06-29 Thread 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

[ANNOUNCE] MyJSQLView Version 3.17 Released

2010-05-20 Thread 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

[GENERAL] Table Column Retrieval

2010-02-22 Thread 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

[ANNOUNCE] MyJSQLView Version 2.86 Released

2008-03-22 Thread 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

Re: [GENERAL] pain of postgres upgrade with extensions

2008-03-12 Thread 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

Re: [GENERAL] how do you write aggregate function

2008-03-09 Thread 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

Re: [GENERAL] how do you write aggregate function

2008-03-09 Thread dmp
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

Re: [GENERAL] Changing column names in tables 2

2008-03-05 Thread 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

[GENERAL] PostgreSQL Array Use

2008-03-03 Thread 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

Re: [GENERAL] PostgreSQL Array Use

2008-03-03 Thread 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

[ANNOUNCE] MyJSQLView Version 2.81 Released

2008-02-09 Thread 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

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

2008-01-14 Thread 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

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

2008-01-14 Thread 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

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

2007-04-17 Thread 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

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

2007-03-29 Thread 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

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

2007-02-27 Thread 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

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

2007-02-27 Thread 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] [JBoss Seam] - Re: Seam 1.2 released

2007-02-27 Thread 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 :

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

2007-02-27 Thread 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

[Ida-Krisna Show] Workshop Pembuatan Legal Opinion

2006-05-23 Thread 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

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

2005-12-06 Thread 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 Dal

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

2005-12-01 Thread 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 Dal

[Ida-Krisna Show] (unknown)

2005-11-28 Thread 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 Dal

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

2005-11-28 Thread 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 Dal

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

2005-11-23 Thread 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 Dal

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

2005-11-21 Thread DMP Advocates
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

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

2005-11-21 Thread DMP Advocates
, 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

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

2005-11-21 Thread DMP Advocates
, 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

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 ...

2005-08-13 Thread 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

  1   2   >