Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Monday, June 4, 2012

Is there a .NET/C# wrapper for SQLite?


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?

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 :

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.