I'd sort of like to use SQLite from within C#.Net, but I can't seem to find an appropriate library. Is there one? An official one? Are there other ways to use SQLite than with a wrapper?
Ccna final exam - java, php, javascript, ios, cshap all in one. This is a collaboratively edited question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
Monday, June 4, 2012
Is there a .NET/C# wrapper for SQLite?
Friday, June 1, 2012
How to secure database passwords in PHP?
When a PHP application makes a database connection it of course generally needs to pass a login and password. If I'm using a single, minimum-permission login for my application, then the PHP needs to know that login and password somewhere. What is the best way to secure that password? It seems like just writing it in the PHP code isn't a good idea.
Friday, May 25, 2012
Good PHP ORM Library?
Is there a good object-relational-mapping library for PHP?
I know of PDO /ADO, but they seem to only provide abstraction of differences between database vendors not an actual mapping between the domain model and the relational model. I'm looking for a PHP library that functions similarly to the way Hibernate does for Java and .NET.
Wednesday, May 23, 2012
Database Structure Advice Needed
Im currently working on a site which will contain a products catalog. I am a little new to database design so I'm looking for advice on how best to do this. I am familiar with relational database design so I understand "many to many" or "one to many" etc (took a good db class in college). Here is an example of what an item might be categorized as:
Sunday, May 20, 2012
What database does Facebook use?
Does it use any of the standard ones like Oracle, DB2, SQL Server, or have something of their own?
Wednesday, May 16, 2012
Get last record of each month in MySQL…?
I have a problem in writing a query for MySQL. I have following fields in the DB
Is it ok to store presentation data in the database?
I am to displaying rows from a database (SQL SERVER 2005) table in a webpage. These rows contain a statusID (foreign key) that is further defined by Status table (eg. id, name, modifiedDate).
Wednesday, May 9, 2012
Get database schema with one query?
Basically I want to get the table names, and the field names for each table from the current database that is connected, nothing else.
SQL query is much faster if I create indexes
Is it ok if I create like 8 indexes inside a table which has 13 columns?
Friday, May 4, 2012
How to store Markdown comments
I want to use Markdown for my website's commenting system but I have stumbled upon the following problem: What should I store in the database - the original comment in Markdown, the parsed comment in HTML, or both?
Thursday, March 1, 2012
database insertion working well on android emulator but not on device
I have created a database using this tutorial .
Android database closed exception
I'm working on a project where I'm downloading and saving data from web to sqlite database. A few minutes ago I receive a strange exception to our server from a user which is saying that the sqlite database is already closed..and I just checked the whole file where the exception happened and I'm not calling dbHelper.close();
. Here is the function where the app crashes and LogCat message :
Tuesday, February 28, 2012
ResultSet How to get strin from object when data is null?
In my Oracle table there are columns with different type.
Friday, February 24, 2012
Very slow query where table have many records
I' m using sqlite on iphone. I have table with 200 000 records. It' s size is small, only 2 MB. I' m doing standard select(3 collumns) with two simple condtions. I' m operating only on integer values( in return and condtion). All data are unique. I'm get usually only 10-50 records from database.
Tuesday, February 21, 2012
browser keeps on looking for the data but never fetches it
Following is a snippet that is meant to fetch the data from the database. But when i click the submit button to see the data, the browser keeps on looking for the data but never displays anything (the browser doesn't show the next page but keeps on looking on the same page) . I don't know what the problem is.
Thursday, February 16, 2012
Is it possible to show screen only once when app starts up?
I want to be able to prompt the users to enter the details required for the app only when it starts up for the first time (not other times). These details will be held in a database on the phone.
Friday, February 10, 2012
Registration blanket, database, info, wordpress, mySQL, e-mail
I'm making websites for a company where users have to "register" with names and a lot of different information to attend the event. (It's a video-event - info would be name, e-mail etc.)
Sunday, January 29, 2012
Distinguish new vs existing exceptions
I am creating a PHP application and I want to display the number of times an error has occurred. The problem that I am trying to figure out is if an error has already been reported or if its new using the following values:
Friday, January 13, 2012
Apostrophe issue when inserting into MySQL
I have a script where I submit some fields that get entered into a MySQL database when I submit it now it goes through successfully but never gets inserted into the database if one of the fields has an apostrophe. What can I modify to get this to work?
Doctrine 1.2 / Zend
Im having trouble with doctrine generating the code for a query that has a umlaut in.